Re: CF Query Column Order - Random?

2001-02-09 Thread David Shadovitz
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

Fw: Re: CF Query Column Order - Random?

2001-02-09 Thread David Shadovitz
: 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

RE: CF Query Column Order - Random?

2001-02-08 Thread Bob Silverberg
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

Re: CF Query Column Order - Random?

2001-02-07 Thread Clint Tredway
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

RE: CF Query Column Order - Random?

2001-02-07 Thread Caulfield, Michael
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.

Re: CF Query Column Order - Random?

2001-02-07 Thread cftalk
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?

Re: CF Query Column Order - Random?

2001-02-07 Thread Billy Cravens
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