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.
To debug, you could attempt to dump the result-set with cfoutput, as follows:
<cfloop list="#queryName.ColumnList#" index="column">
Otherwise, could you show us your code? Many more eyes may spot something you overlook.