> what's the easiest way to get the outut of a query into a list?
>
> ex.
>
> <CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#">
> SELECT ID, Title, Name
> FROM Options
> </CFQUERY>
>
> and I want to access the resulting Names as a list?
>
> List(rob,ray,eddie,eagle)
The easiest way is to use the ValueList function:
ValueList(getOptInfo.Name)
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
