Let me expand on Michael's mention of WDDX. (Thanks, Michael, for
pointing me in this direction.)
The WDDX packet contains a "recordset" tag which has a "fieldNames"
attribute. The value of this "fieldNames" attribute is a list of the
fields in the same order as they appear in the SELECT
: David Shadovitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Date: Thu, 8 Feb 2001 21:23:51 -0800
Subject: Re: CF Query Column Order - Random?
Let me expand on Michael's mention of WDDX. (Thanks, Michael, for
pointing me in this direction.)
The WDDX packet contains a "recordset
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
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
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.
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?
cfx_QueryColumns
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347299-2830-11D4-AA9700508B94F380method=Full
Scott Becker wrote:
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
7 matches
Mail list logo