ValueList() or QuotedValueList()
Joseph E. Sheble
a.k.a. Wizaerd
Wizaerd's Realm
Canvas, 3D, Graphics,
PHP/mySQL & ColdFusion/MSSQL
http://www.wizaerd.com
=================================
The Canvas Expert Online
The #1 Resource For Canvas Information
http://www.TheCanvasExpert.com
=================================
> -----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
