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]
