<CFQUERY NAME="qry"... </CFQUERY>
<CFSET strQuery = StructNew()>
<CFLOOP LIST="#qry.ColumnList#" INDEX="idxColumn">
<CFSET strQuery[idxColumn] = qry[idxColumn][1]>
</CFLOOP>
<CFDUMP VAR="#strQuery#">
HTH
-----Original Message-----
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 12:42
To: CF-Talk
Subject: Query to structure
Hello
I have a query which returns one row with a lot of columns...
I want to take the query and convert it to a structure, with the key being
the column name and the value being the value of the column...
How do you do this?
Ryan
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]