Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

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

Community Beginner ,
Sep 19, 2014 Sep 19, 2014

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.

TOPICS
Advanced techniques
383
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 21, 2014 Sep 21, 2014
LATEST

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources