Tim;
How about:
<cfoutput query="qGetRecords">
<cfset lstRecords = "#lstRecords#~'#B_FName#','#B_LName#','#Address#'~
">
</cfoutput>
Seperate your records by a tilda and then split them out later by looking
for
a double tilda.
-----Original Message-----
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 12: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!
______________________________________________________________________
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
