<cfset qryList = ""> <cfoutput query="test"> <cfset qryList = ListAppend(qryList,"#name#,#address#,#phone#","#chr(7)#"> </cfoutput>
You can then get each list by breaking it down to smaller lists by using chr(7) as your delimiter. ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com -----Original Message----- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 1:08 PM To: CF-Talk Subject: creating a list from a query 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? <cfquery name="test" datasource="names" select * from finals where name = #form.name# <cfquery> I need to be able to search the list for specific values later. __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists