RE: query.ColumnList Question

[Mike Townend]

you could potentially create a CF list and use that in the query instead,
something like


<CFSET lstCols = "id,foo">


<CFQUERY>
    SELECT #PreserveSingleQuotes(lstCols)#
    FROM...
</CFQUERY>


<CFLOOP List="#lstCols#" INDEX="idxCol">
    #qryFoo[idxCol][1]#<br>
</CFLOOP>

HTH

-----Original Message-----
From: David Adams [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 27, 2003 15:48
To: CF-Talk
Subject: query.ColumnList Question

A characteristic of the ColumnList variable is that it returns a list of the
column names in alphabetical order.  Is there anyway to get the same list
but in the order that specified in the select statement?

Thanks in advance.  Dave Adams
  _____  

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---