<CFSET lstNames = #ValueList(getOptInfo.Name)#>
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-----Original Message-----
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 9: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
