ColdFusion Query object with columns in correct order?

[tommuck1]

I know this is a long standing issue with ColdFusion, and there are many workarounds, but is there an easy way to get the query object to have the columns in the correct order without jumping through hoops? I haven't dealt with it before because I always had display outputs that were manually put together, but when I started using the spreadsheet functions -- spreadsheetAddrows() puts the data into a spreadsheet with the columns in the wrong order. Any easy fix? 

Tom Muck

[Larry C. Lyons]

Glad to help. I had stumbled over it a few years ago and just kept it in my snippets collections. That said, remember this is an undocumented feature (although it is listed in the Dreamweaver help), so no idea if it is going to go away with an update in the future.