Forum: ColdFusion  Jul 29th, 2008 |
| Replies: 8 Views: 2,236 |
| Forum: ColdFusion Jul 16th, 2008 |
| Replies: 3 Views: 1,231 You need to create the datasource in the ColdFusion administrator if you have access to it. |
| Forum: ColdFusion Jul 16th, 2008 |
| Replies: 8 Views: 2,236 Here goes. There's a lot here, so bear with me. This is actually two custom tags. One to set the variables and one to create the links.
Here is the first custom tag:
<!--- pageNumSetup.cfm... |
| Forum: ColdFusion Jul 16th, 2008 |
| Replies: 8 Views: 2,236 OK. I have a custom tag that will pretty much do everything for you. I'll post it in the morning when I get back to work. |
| Forum: ColdFusion Jul 15th, 2008 |
| Replies: 8 Views: 2,236 Are you permitted by your hosting company to use custom tags? |
| Forum: ColdFusion Jul 14th, 2008 |
| Replies: 8 Views: 2,236 Based on query data? If so yes, but I don't have it with me at the moment. I'll get back to you. |
| Forum: MS SQL Jul 11th, 2008 |
| Replies: 8 Views: 1,213 Can you give me a little more information about what this particular query is trying to do? You may not need to use UNION, but perhaps different JOINs. |
| Forum: MS SQL Jul 11th, 2008 |
| Replies: 8 Views: 1,213 Try this:
SELECT
hourStamp,
NULL AS ActualVisits,
SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage,
SUM(CASE WHEN dateStamp BETWEEN... |
| Forum: ColdFusion Jul 8th, 2008 |
| Replies: 11 Views: 4,367 http://www.paulschou.com/tools/iso8859.html has a pretty comprehensive list. It's a lot to wade through, but you'll probably never need to look anywhere else.
BTW, is this for an engineering... |
| Forum: ColdFusion Jul 7th, 2008 |
| Replies: 11 Views: 4,367 Found it!
This will replace 67 special characters with their HTML equivalent. I've used this to generate RSS feeds before, so it should work just fine for you.
<cffunction name="formatXML"... |
| Forum: ColdFusion Jul 4th, 2008 |
| Replies: 11 Views: 4,367 I have a CFC method somewhere that replaces around 30 commonly used symbols. If I can find it, I'll post it. |
| Forum: ColdFusion Jul 2nd, 2008 |
| Replies: 11 Views: 4,367 Strange. You may need to replace it with °, still inside the cdata. I don't remember the ascii codes for the decimal character, but I'm sure that's pretty easy to find. |
| Forum: ColdFusion Jul 2nd, 2008 |
| Replies: 11 Views: 4,367 Wrap your content inside a <![CDATA[ ]]> tag. XML will ignore any special characters inside.
<instrumentation.InstrRange><![CDATA[-40° to 70°C]]></instrumentation.InstrRange> |
| Forum: ColdFusion Jun 29th, 2008 |
| Replies: 3 Views: 1,643 I'm glad I could help. Please mark the thread solved. |
| Forum: ColdFusion Jun 23rd, 2008 |
| Replies: 3 Views: 1,643 Here's one way:
Get your db information before you output the <head> tag on your page.
Inside the <title> tag, output the info from your query. For example:
<cfquery datasource="dsn"... |
| Forum: ColdFusion Jun 23rd, 2008 |
| Replies: 3 Views: 2,973 Use SCOPE_IDENTITY(). It will return the id of the record just created, provided the field is set as the identity column.
<cffunction name="insertData" access="public">
<cfargument... |
| Forum: ColdFusion Apr 10th, 2008 |
| Replies: 2 Views: 2,613 You need to use a javascript function for this:
function ChangeButtonStatus()
{
if (document.getElementById("Text").value.length > 0)
{
... |
| Forum: ColdFusion Mar 28th, 2008 |
| Replies: 2 Views: 2,806 First of all, please don't name your query cool.recordCount. RecordCount is a property of the query object. Name it something like qryCool.
Secondly, you're missing a </cfif> tag. You have two... |
| Forum: MS SQL Mar 24th, 2008 |
| Replies: 2 Views: 3,612 Not sure if this is what you are looking for:
DECLARE tempCursor CURSOR FOR SELECT col3 FROM table1 WHERE col2 = @col2
OPEN tempCursor
DECLARE @value As int --or whatever your datatype is
... |
| Forum: ColdFusion Mar 24th, 2008 |
| Replies: 1 Views: 1,224 I'm not sure I understand what you are looking for. Can you please post some code? |
