Scott--
I think the order is alphabetical (if I remember correctly). To get the
actual order you can either use a database server specific method (get
colorder from the table syscolumns in SQL Server) or you can WDDX the query,
which for some reason outputs the columns in the right order.
Michael Caulfield
Cognitive Arts
(847) 425-8529
-----Original Message-----
From: Scott Becker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 11:53 AM
To: CF-Talk
Subject: CF Query Column Order - Random?
When you make a <CFQUERY>, the variable queryName.columnList variable
returns a list
of field names from the query. However, this order doesn't appear to reflect
the order
of columns from the SELECT statement, or the table itself. Is there some
logic
to how its ordered? And, is there a way to access the columns in the order
of the
SELECT statement?
Thanks,
Scott
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
