ValueList(getOptInfo.name)
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 10:47 AM
> To: CF-Talk
> Subject: query result to list
>
>
> Hi all,
>
> 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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists