Here is some code that will do it, assuming cList is your list of columns
and q is your query

<cfoutput query="q">

<cfloop index="column" list="#qList#">
The value of #column# is #q[column][currentRow]#<br>
</cfloop>

<br>

</cfoutput>

-Raymond Camden

> -----Original Message-----
> From: Morgan Senkal [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 30, 2004 2:49 PM
> To: CF-Talk
> Subject: Query manipulations...
>
> I have the following situtation:
>
> I receive a comma-delimited list of column names.  I need to
> output a query which follows the ORDER of the columns in that
> list.  The items in the list contain the same names as the
> column names in the query.  If queries were structures, it
> would be cake...but alas they are not!
>
> Using CF5.
>
> Any help is appreciated, been banging my head on my monitor
> for a couple days on this one...
>
> Thanks in advance!!!
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to