Something like this should work. Lookup the columnList property in the CF
manual.
<cfquery name="myQuery" datasource="names">
select *
from finals
where name = #form.name#
</cfquery>
<cfset myValList = "">
<cfloop list = "#myQuery.columnList#" index = "i">
<cfset myValList = listappend(valuelist(evaluate("myQuery." & i)))>
</cfloop>
----- Original Message -----
From: "Tim" <[EMAIL PROTECTED]>
I need to create a comma delineated list of all field
values generated from a query. I know ValueList will
create a list, but from what I can tell it will only
create a list of values from one column for all
records. Is the a way to create a list of all fields
for one record?
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
