Order of columns should not matter. Why does it in your case? On Wed, Dec 8, 2010 at 3:48 PM, Janet Whittredge <[email protected]>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:339927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

