> From: "Eric Creese"
> I want to replace the script above with the dynamic output list using a query like this
>
> <cfquery name="getimglist" datasource="foo">
> SELECT 'images/'+''+signimage AS myImg
> FROM signs
> WHERE signtype =1;
> </cfquery>
> .
<cfset myList = ListToArray(ValueList(getimglist.myImg))> should do the trick.
Note that you do need to alias that column in the query.
Scott
---------------------------
Scott Brady
http://www.scottbrady.net/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
