<cfquery name = "sortableDate" datasource="NJDB">
    select replace((convert(varchar, GETDATE(), 111)),'/','') as theDate
</cfquery>

<cfset fileName="MyTest#sortableDate.theDate#.xml" />
<cfset outputfile="d:\test\#fileName#" />

<cfdump var="#fileName#">
<cfdump var="#outputFile#">
<cfdump var="#fileExists(outputFile)#">

<cfftp
    action="putFile"
    server="204.232.225.62"
    username="anonymous"
    password="user@email.com"
    transferMode="binary"
    localfile="#outputFile#"
    remotefile="#fileName#" >



MyTest20100318.xml   d:\test\MyTest20100318.xml   YES

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.

Null Pointers are another name for undefined values.

The error occurred in D:\sites\NationJob\Exports\scripts\ftptest.cfm: line 19

17 :    transferMode="binary"
18 :    localfile="#outputFile#"
19 :    remotefile="#fileName#" >

Resources:

    * Check the ColdFusion documentation to verify that you are using the correct syntax.
    * Search the Knowledge Base to find a solution to your problem.

Browser     Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 GTB6 (.NET CLR 3.5.30729)
Remote Address      192.168.0.240
Referrer
Date/Time       18-Mar-10 04:47 PM
Stack Trace
at cfftptest2ecfm103194893.runPage(D:\sites\NationJob\Exports\scripts\ftptest.cfm:19)

java.lang.NullPointerException
    at coldfusion.runtime.NeoPageContext.findAttribute(NeoPageContext.java:575)
    at coldfusion.tagext.net.FtpTag.doInterfaceSetup(FtpTag.java:632)
    at coldfusion.tagext.net.FtpTag.doStartTag(FtpTag.java:667)
    at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
    at cfftptest2ecfm103194893.runPage(D:\sites\NationJob\Exports\scripts\ftptest.cfm:19)