Highlighted

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

Community Beginner ,
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

296

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

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

Community Beginner ,
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

297

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
Sep 19, 2014 0
BKBK LATEST
Adobe Community Professional ,
Sep 21, 2014

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.

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
Reply
Loading...
Sep 21, 2014 0