Kit)
Don't let the price scare you. Many totally usable versions (you don't NEED
the latest edition) are for sale used on Amazon for under $5
-----Original Message-----
From: Morgan Senkal [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 1:26 PM
To: CF-Talk
Subject: Re: Query manipulations...
Thanks to both of you, that worked! Wasn't aware of the ability to use []
in queries....anywhere I can look to find out more about it?
>Morgan, this should do it
>
><cfset yourlist = "colname1,colname4,colname3">
><cfquery name="yourQuery" ...>
>...</cfquery>
>
><cfloop query="yourQuery">
><cfloop list="#yourlist#" index="oneCol"> <!--- this forces your desired
>order --->
> <cfoutput>#yourQuery.oneCol[currentRow]#<br></cfoutput>
></cfloop>
></cfloop>
>
>-----Original Message-----
>From: Morgan Senkal [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, March 30, 2004 12: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]
