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]
