There's a tag on the developer's exchange called CFX_QueryColumns, that
returns the List of Columns in the same order as that returned by the
database. This may help you do what you want.
Bob
-----Original Message-----
From: Scott Becker [mailto:[EMAIL PROTECTED]]
Sent: February 7, 2001 12:53 PM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
