You could do something like,
<cfset lst_ID=ValueList(getOptinfo.ID)>
<cfset lst_Title=ValueList(getOptinfo.Title)>
<cfset lst_Name=ValueList(getOptinfo.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
