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

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

Community Beginner ,
Sep 19, 2014 Sep 19, 2014

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.

TOPICS
Advanced techniques

Views

346

Translate

Translate

Report

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

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

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
Documentation