I figured out what this was.

Security permissions on the cfc folder were blocking ajax requests. What I was getting in response was my site's 404 page.

So in other words, I'm stupid. lol

I recently updated our servers to CF 8.0.1 and now none of my AJAX code works. I checked the XHR response in Firebug and instead of returning the requested data, it returns the HTML code for my...

Here's something to start with. To get the first four characters of the user's name, use the LEFT function. Assuming you have a text box on the form called 'txtName':


<cfset username =...

Anytime. Glad to help.

You need to create the datasource in the ColdFusion administrator if you have access to it.

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...

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.

Are you permitted by your hosting company to use custom tags?

Based on query data? If so yes, but I don't have it with me at the moment. I'll get back to you.

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.

Can you make up some sample data for me? I'll recreate this structure on my server and test it.

Try using != (not equal) instead of NOT LIKE. LIKE is a little more 'fuzzy' than an explicit equal, which is why you did not get the data you were looking for.

Also, one other thing that might...

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...

If you are using SQL 2005, here's another option. (originally posted in http://www.daniweb.com/forums/post639423-7.html)

Suppose you have a table with the following structure:


id - int...

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...

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"...

Go into the ColdFusion Administrator and turn on Robust Debugging. Check the line number and let me know where the error is occurring. I didn't get a chance to actually test this, so I probably...

Couple of things here:

Use CFFILE to upload the files to the server.

(http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_02.html#4003197)

You also need to change the...

I have a CFC method somewhere that replaces around 30 commonly used symbols. If I can find it, I'll post it.

Strange. You may need to replace it with &deg;, 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.

Wrap your content inside a <![CDATA[ ]]> tag. XML will ignore any special characters inside.


<instrumentation.InstrRange><![CDATA[-40° to 70°C]]></instrumentation.InstrRange>

I'm not aware of any way to get this to work in CF. However, in your SQL query/stored procedure, you could put the data into temp tables, join them there and then return the results to CF. This...

Sorry I didn't get this uploaded the other night, the kids have been sick.

Suppose you have a table with the following structure:


id - int PrimaryKey
name - varchar(50)
description -...

The script is on a different computer. I'll post it when I get home.

What version of MSSQL are you using? If 2005, then I have a query you can modify that will remove duplicate entries.

I'm not sure I understand your question.

I'm glad I could help. Please mark the thread solved.

You can use a second Replace function:


<cfset mailBody = Replace(#form.body#, "{NAME}", #rsSubscribersMail.name#, "all") />
<cfset mailBody = Replace(#mailbody#, "{SURNAME}",...

When you use a variable in the list element of the CFLOOP tag, it must be enclosed in #'s...


<cfset myd = "">
<cfloop list="#form.mydata#" index="i" delimiters=",">
<cfoutput>
<cfset myd...

You need to cfloop through the query.


<cfquery name="rsSubscribersMail" datasource="DATA">
SELECT subscriber.subscriberID, subscriber.name, subscriber.surname, subscriber.email
FROM subscriber...

You can string replace the {NAME} with the user's name (which I assume is on a form somewhere). For example:


<cfset mailBody = Replace(form.body, "{NAME}", form.name, "all") />

In a typical situation, yes, that should be all you need. Provided of course the pages do what they are supposed to.

Of course, your situation may or may not be typical. At this point I would...

That's not so much a coldfusion problem as it is an SQL "feature". Floats are not exact representations of numbers, but approximates. Here's an explanation:...

I'm sorry. I'd love to help you with that but I've never used cfexchangemail. Do you know what the special characters are? If so, perhaps you could strip them from the UID before you pass it to...

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"...

Are you saying that the insert.cfm page is missing?

If so, do you have any information (table structures, etc..) so it can be recreated? I'm more than happy to help if you can give me more info.

Not being able to see the code, I don't have any concrete solutions, but it may be an issue with cookies. If you are able to cancel the second login screen and still get it, that leads me to believe...

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...

You don't technically need any version to code for it, it isn't like Visual Studio. You can code in pretty much any text editor.

But to answer your question, if you are going to buy a new copy of...

I think first of all you need to figure out why your queries are taking longer than 100 seconds. Unless your running a migration script, your queries should be much faster.

Is this the query...