The columnlist is ordered alphabetically.
If you use MS SQL you might find sp_columns 'tablename' useful.
----- Original Message -----
From: "Scott Becker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 11:52 AM
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
