#Valuelist(getoptingo.name)#
|-----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)
|
|thanks,
|
|s
|
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
