Adobe Community: Message List - The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

Re: The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

forums_noreply@adobe.com — Sun, 21 Sep 2014 11:14:10 GMT

To debug, you could attempt to dump the result-set with cfoutput, as follows:

#queryName[column][currentRow]#

</cfloop>

<br>

</cfoutput>

Otherwise, could you show us your code? Many more eyes may spot something you overlook.

The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

forums_noreply@adobe.com — Fri, 19 Sep 2014 19:43:24 GMT

I've done this a thousand times. I have a stored proc that returns data. I give the resultset a name. I output it with cfoutput query =queryname. Now it's failing for every column in the query. But if I do a cfdump with the queryname as a var, I get the data -- with the exact column names in my cfoutput.

CF9, SQL Server.