loop over the list and create a batch file using xcopy then cfexecute it.
> -----Original Message----- > From: Justin MacCarthy [mailto:[EMAIL PROTECTED] > Sent: 29 September 2003 17:57 > To: Cfuk > Subject: [ cf-dev ] SQL Server T-SQL question / File system > > > 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]
