-
From: 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
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 clause
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 P
cfx_QueryColumns
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347299-2830-11D4-AA9700508B94F380&method=Full
Scott Becker wrote:
>
> When you make a , the variable queryName.columnList variable
> returns a list
> of field names from the query. However, this order doesn't appear to re
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?
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.
Michae
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
7 matches
Mail list logo