The columnlist variable is returned in alphabetical order. One way to do it is to
create an outside list of the columns and then use a cfloop with the outside list and
evaluate the variable.. Another way that I saw someone do it was using WDDX, but this
was very complicated and I haven't tried to use it.
My 2cts
--
Clint Tredway
www.factorxsoftware.com
--
---------- Original Message ------------------------
From: Scott Becker <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 07 Feb 2001 12:52:39 -0500
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
