It's faster to build the list in the SQL statement...
[Oracle]
SELECT field1 || "~" || field2 || "~" || field 3
FROM.....
then finish it off with a VALUELIST() function.
But this is pretty specialized so it may not be the right solution for
your
app.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 10:08 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
