https://community.adobe.com/questions-582/the-query-column-candidate-id-appears-in-cfdump-but-not-cfoutput-query-queryname-269894
The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname | Community
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...