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

300

Likes

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
Adobe Community Professional ,
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.

Likes

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