query.getColumnNames() should be able to get your columns in the original order
I can see some cases where the original order is needed, like when outputting dynamic SQL and you want to preserve the column order, i.e. in a SQL client app. On 12/8/2010 1:48 PM, Janet Whittredge wrote: > I call a stored procedure in<cfquery> and the result set returned has all of > the > data the stored procedure generated, but, the column order is changed to > alphabetical order. Why is the resultset changed? Is there any way to get > the data back as it was generated in the stored procedure? ColdFusion 8, MS > SQL Server 2005, Windows Server 2003 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
