If you don't want to use cffile, you can generate a script with multiply copy statements using a query, save it into a .bat file and then execute it some way or another.
Either in cold fusion or in SQL using xp_cmdshell (check BOL for a sample). -----Original Message----- From: Justin [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 6:18 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL Server T-SQL question / File system Oh yeah, forgot to mention, outside cf :-) Justin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 September 2003 18:07 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SQL Server T-SQL question / File system what would be wrong with this: <cfloop query="getPaths"> <cffile action="Move" source="#getPaths.OldFilePath#" destination=" #getPaths.NewFilePath#"> </cfloop> I'm assuming it would be too slow for that many files?. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Justin MacCarthy" To: "Cfuk" <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: rthy.org> Subject: [ cf-dev ] SQL Server T-SQL question / File system 29/09/2003 17:57 Please respond to dev I have a SQL question, I have a Recordset like so (several 10,000 records) OldFilePath NewFilePath ----------------------------- \\a\b\c\d.txt \\12098.txt I want to loop over the files and Move the files from OldFilePath to NewFilePath. I guess I chould use cfexecute do this, with a cursor, but is there any better way? Thanks @J -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
