Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
To debug, you could attempt to dump the result-set with cfoutput, as follows:
<cfoutput query="queryName">
<cfloop list="#queryName.ColumnList#" index="column">
#queryName[column][currentRow]#
</cfloop>
<br>
</cfoutput>
Otherwise, could you show us your code? Many more eyes may spot something you overlook.