You could try something like...
<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]
- Query to structure Ryan Mitchell
- RE: Query to structure Mike Townend
- RE: Query to structure Tim Blair
- Re: Query to structure Ryan Mitchell
- Re: Query to structure Deanna Schneider