Why don't you just CFLOOP over the query? You don't need to convert
the query to a comma list to loop over it...
CFLOOP query=qry_name)
...cf code...
/CFLOOP
Andrew.
- Original Message -
From: Mark Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 21:07:07 +1200
Subject: Converting
Mark,
Not sure if I understand your question but maybe ValueList()
May be of some help?
Kola
-Original Message-
From: Mark Henderson [mailto:[EMAIL PROTECTED]
Sent: 23 September 2004 10:07
To: CF-Talk
Subject: Converting query to comma separated list
My first question, though I
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than necessary. Here's what works
cfdirectory
name=getAllFolders
action="">
directory=#serverdir#
sort=name ASC
cfloop query = getAllFolders
Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than
Henderson [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than
: Thursday, September 23, 2004 09:37 am
To: CF-Talk
Subject: Re: Converting query to comma separated list
Mark,
I posted a CFC called queryTool to my site (http://clearsoftware.net
- downloads - queryTool) and to cfcZone.org that converts queries to
delimited formats, XML, arrays
My first question, though I suspect this might not be the best
approach . Is it possible to turn a query (cfdirectory in this case)
into a comma separated list?
Mark,
There's a UDF on CFLib called QueryToCsv that does exactly that, turn query results into a CSV list:
- Original Message -
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thu, 23 Sep 2004 10:18:25 -0400
Subject: RE: Converting query to comma separated list
To: CF-Talk [EMAIL PROTECTED]
Joe,
Got the following error trying to access your site
Error Executing Database Query.
[Macromedia
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 01:37 pm
To: CF-Talk
Subject: Re: Converting query to comma separated list
Thanks Scott,
This pops up every 24-36 hours until
Got the tool Joe thanks! Ironically it appeared that even after doing what I did it was still nice to have them in a list for use elsewhere, and this is now working with your cfc.
Andrew,I'm testing on mx and 5, in which case I usually just do something like
cfoutput query=queryname
cfif
10 matches
Mail list logo