That look like what I was thinking of. Just make sure that if you are
using an older version of CF (CF4/5 I think) that CFDIRECTORY returned
the . and .. directories, but CFMX doesn't do this. As you say it
works I'm guess you are on CFMX.
Andrew.
----- 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]
- Converting query to comma separated list Mark Henderson
- Re: Converting query to comma separated list Andrew Dixon
- RE: Converting query to comma separated list Kola Oyedeji
- Re: Converting query to comma separated list Mark Henderson
- Re: Converting query to comma separated list Andrew Dixon
- Re: Converting query to comma separated list Joe Rinehart
- Re: Converting query to comma separated list Larry Lyons
- RE: Converting query to comma separated list SStewart
- Re: Converting query to comma separated list Joe Rinehart
- RE: Converting query to comma separated list SStewart
- RE: Converting query to comma separated list Mark Henderson