Sorry I may have not specified this correctly. I need to put each dir name into a table
-----Original Message----- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 1:38 PM To: CF-Talk Subject: Re: get directory name - one more thing I use <cfoutput query="NameOfDirCall"> I suppose you could use <cfloop query=""> too. On Wed, 24 Nov 2004 13:27:49 -0500, Robert Orlini <[EMAIL PROTECTED]> wrote: > 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:185345 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