How to use CFFILE to rename files

[alecken]

I tired the following and got error, please help!
All I need is appending all the files within FolderA with "Version1_" in
front of the file name and move them thereafter to FolderB

<CFDIRECTORY Name="GetFiles" ACTION="List"
DIRECTORY="D:\www-root\MyApp\Uploads\FolderA\" filter="*.*">
<cfquery dbtype="query" name="FilesOnly">
SELECT * FROM GetFiles
Where Type='File'
</cfquery>

<cfloop query="FilesOnly">
<CFFILE action="RENAME" source="D:\www-root\MyApp\Uploads\FolderA"
destination="D:\www-root\MyApp\Uploads\FolderB" file="Version1_#Name#">
</cfloop>

I got this error:
Error Diagnostic Information
Error processing CFFILE
Unable to move file 'D:\www-root\MyApp\Uploads\FolderA' to path
'D:\www-root\MyApp\Uploads\FolderB'. Access is denied. (error 5)

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (17:3) to (17:123) in the template file
D:\www-root\MyApp\webtool\directorytest.cfm.

[alecken]

:cool;
Thank you so much!!! I did not realize how easy it is....THANK YOU!!!!

[_jt]

I think your syntax is off. The source and destination should include the
file name and extention.

<!--- insert the correct directory names --->
<CFDIRECTORY Name="GetFiles" ACTION="List" DIRECTORY="c:\temp\FolderA\"
filter="*.*">

<CFLOOP QUERY="GetFiles">
<CFIF Type IS "File">
<CFOUTPUT>Moving and renaming #Name#</CFOUTPUT><br>
<CFFILE ACTION="rename" SOURCE="c:\temp\FolderA\#Name#"
DESTINATION="c:\temp\FolderB\Version1_#Name#">
</CFIF>
</CFLOOP>



I think one of the previous responders mentioned this .. CFDIRECTORY returns
a query, so you don't need to use a query of a query.


"alecken" <webforumsuser@macromedia.com> wrote in message
news:d727sl$308$1@forums.macromedia.com...

> I tired the following and got error, please help!
> All I need is appending all the files within FolderA with "Version1_"

in

> front of the file name and move them thereafter to FolderB
>
> <CFDIRECTORY Name="GetFiles" ACTION="List"
> DIRECTORY="D:\www-root\MyApp\Uploads\FolderA\" filter="*.*">
> <cfquery dbtype="query" name="FilesOnly">
> SELECT * FROM GetFiles
> Where Type='File'
> </cfquery>
>
> <cfloop query="FilesOnly">
> <CFFILE action="RENAME" source="D:\www-root\MyApp\Uploads\FolderA"
> destination="D:\www-root\MyApp\Uploads\FolderB" file="Version1_#Name#">
> </cfloop>
>
> I got this error:
> Error Diagnostic Information
> Error processing CFFILE
> Unable to move file 'D:\www-root\MyApp\Uploads\FolderA' to path
> 'D:\www-root\MyApp\Uploads\FolderB'. Access is denied. (error 5)
>
> The error occurred while processing an element with a general identifier

of

> (CFFILE), occupying document position (17:3) to (17:123) in the template

file

> D:\www-root\MyApp\webtool\directorytest.cfm.
>
>
>
>