Skip to main content
Participant
September 19, 2014
Question

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

  • September 19, 2014
  • 1 reply
  • 425 views

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.

This topic has been closed for replies.

1 reply

BKBK
Community Expert
Community Expert
September 21, 2014

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.