<CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#">
SELECT ID, Title, Name
FROM Options
</CFQUERY>
<cfset list = ValueList(getOptinfo.Name)>
look up query functions in cfdocs for moore info...
-----Original Message-----
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 15:47
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
