Dynamic list generation

Original Message: > 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/