Have you tried specifying the order of the columns (random shot in the dark, not sure if it works) like this:
<CFQUERY> select table1.column1, table1.column2, table1.column2 from table1 </CFQUERY> . . . I'm just not sure why it would matter the order in which the columns are returned. A query object is an array of structures. One element in the array for each row in the result set. And each row contains a structure... What is the application? At 03:43 PM 10/04/2001 -0700, you wrote: >How to preserve the ordering of columnlist returned by cfquery. >By default it is ordering by alphabetical. >I need the same column order specified in table. > >-Saro > > > >-- >saro cf >[EMAIL PROTECTED] - email >(818) 630-2340 x6093 - voicemail/fax > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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