I just saw Saro's post from early October, complaining about the ordering of the columns in CFQUERY's ColumnList property.
I have a pure-CFML custom tag, CF_ColumnList, which will return the columns in the order you'd expect. The tag is available at Allaire's Developers Exchange; here's a direct link to it (watch the wrap): http://devex.allaire.com/developer/gallery/info.cfm?ID=21A0C6D7-17C9-11D5-83 EE00508B94F85A&method=Full I have an example of how to use it at: http://members.evolt.org/dshadovi/cf_columnlist/cf_columnlist_example.cfm -David ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists