works fine Ian thank you.
One more thing please: How can I add each directory name into a table using a
cfquery?
I have this:
<CFQUERY name="get" datasource="marketing">
INSERT INTO directories (name)
VALUES ('#mydirectory.name#')
</CFQUERY>
But it adds just the first entry. I guess your gonna say use a cfloop, if so
what type?
Robert O.
-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 11:18 AM
To: CF-Talk
Subject: RE: get directory name
Thanks Ben and Greg.
I'm using the CFDirectory example on Macromedia's site. It lists the directory
name and size of files found.
One step further: How can I filter out any files (if #size# = 0 which means it
is a directory name and not a file) and then insert the directory names in a
table?
Robert O.
Instead of using "size", I would use the "type" field which equals "file" for
files and "dir" for directories.
<cfdirectory
directory="#GetDirectoryFromPath(GetTemplatePath())#"
name="myDirectory">
<cfloop query="myDirectory">
<cfif type EQ "dir">
<!--- Do something, I'm a directory --->
</cfif>
</cfloop>
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
