Webmaster Forum / ColdFusion / Advanced Techniques / May 2008

Don't want to look it up and learn form the convenient links provided, eh?

http://livedocs.adobe.com/coldfusion/8/htmldocs/Expressions_09.html

Normally one would use double hash|pound symbols to escape it.  But if
you properly write your expressions you would not need any.

<CFSET temp1 = "method, device, disposition, completed_by,
who_intubated_1, who_intubated_fellow_1, cricoid_1">
<cfset myquery = QueryNew(temp1)>
<cfset temp = QueryAddRow(myquery, NumRecords)>

<cfoutput>
<cfloop index="i" from = "1" to = NumRecords>
    <CFLOOP list=temp1 index="what">
        <cfset temp = QuerySetCell(myquery, What,
getRecords.qdbapi.record[i][what].XmlText, i)>
    </CFLOOP>
</CFLOOP>

Untested code, but should be close.

Now I can chalk up another fifteen minutes of "Mentoring Junior Staff"
to my State Promotion Exam.

Of course I do.  *Me* knowing how to fix it is not the point of this... YOU
need to know how to fix it.

And if you went and read those docs I pointed you at, you'd be able to.

I'm not simply going to give you the answer, because you'll not then
understand why it's the answer.  Which means the next time something
similar crops up, you'll be back here, rather than knowing how to sort it
out yerself.

FWIW, one of Azadi's answers is correct, and the error message is telling
you something else is wrong with your code.

Read the docs, look at the error messages, and look at what one of those
error messages is telling you.