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, and structures. Perfectly free, seems
to work pretty well.
Cheers,
Joe
----- Original Message -----
From: Mark 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 necessary. Here's what works....
<cfdirectory
name="getAllFolders"
action=""> directory="#serverdir#"
sort="name ASC">
<cfloop query = "getAllFolders">
<cfdirectory
name="getAllFiles"
action=""> directory="#serverdir##name#"
sort="name ASC">
<cfquery dbtype="query" name="getAllFiles_#name#">
SELECT *
FROM getAllFiles
</cfquery>
</cfloop>
adieu
Mark________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
