ValueList(), but this is only for one column of the query.
-----Original Message-----
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 3:12 PM
To: CF-Talk
Subject: Simple: How do I get query results in a list
I have a query like:
<cfquery name="getNumbers" datasource="whatever">
select field1
from myTbl
where field2=100
</cfquery>
How do I output the result set as a list? I think there is a built-in
function for this but I can't remember what it is and can't find it in my CF
bibles.
Thanks,
Paul Sinclair
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
