All I'm trying to do is move a file from one folder to another folder in the same directory. When I display the source and destination paths just prior to the CFFILE, the paths are correct. But, when the CFFILE executes, there is an extra "\" in front of the file name that isn't there the step before, so it errors out. Here is the code; what am I doing wrong? :-(
<!--- Get document information --->
<cfquery name="GetDocInfo"
datasource="#Application.Datasource#">
SELECT *
FROM DocumentTable
WHERE DocID = '#URL.Document#'
</cfquery>
<cfoutput>
<font size="+2" color="Red">
Source: #Application.DocLocation##GetDocInfo.DocFileName#
</font>
</cfoutput>
<br><br>
<cfoutput><font size="+2" color="Blue">Destination: #Application.RootPath#Archive/#GetDocInfo.DocFileName#</font></cfoutput>
<!--- Move file to archive folder --->
<cffile action="MOVE"
source="#Application.DocLocation##GetDocInfo.DocFileName#"
destination="#Application.RootPath#Archive/#GetDocInfo.DocFileName#">
Calista :-X
Jedi Knight,
Champion of the Force
<!--- Get document information --->
<cfquery name="GetDocInfo"
datasource="#Application.Datasource#">
SELECT *
FROM DocumentTable
WHERE DocID = '#URL.Document#'
</cfquery>
<cfoutput>
<font size="+2" color="Red">
Source: #Application.DocLocation##GetDocInfo.DocFileName#
</font>
</cfoutput>
<br><br>
<cfoutput><font size="+2" color="Blue">Destination: #Application.RootPath#Archive/#GetDocInfo.DocFileName#</font></cfoutput>
<!--- Move file to archive folder --->
<cffile action="MOVE"
source="#Application.DocLocation##GetDocInfo.DocFileName#"
destination="#Application.RootPath#Archive/#GetDocInfo.DocFileName#">
Calista :-X
Jedi Knight,
Champion of the Force