Loop over the query with cfloop and append to a list with ListAppend function.
HTH
Dick
At 6:11 PM -0400 6/11/01, Paul Sinclair wrote:
>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
