Parameter 1 of function toBinary which is now '<data>' must be a base64-encoded string?

[Nate]

Hi All,

I have some file upload/download code that used to be working, but
suddenly stopped working with the error 'Parameter 1 of function
toBinary which is now '<data...>' must be a base64-encoded string?'. I
am using MS SQL 7.0 with nText size 16 datatype, and Cold Fusion 4.5.
When I run the following code, I get the above error at the line with
the <CFFILE> tag.


<!---------------------------------------
Set zip file source and destination information.
---------------------------------------->
<CFSET originalname = "#zipurl#"> <!---(From table)--->
<!--- Setup a temp filename. --->
<CFSET zipsourceurl =
"#ExpandPath(APPLICATION.ZIPPATH)#\#randRange(1000 00,999999)#.zip">
<!--- Write the file to disk --->
<CFFILE ACTION="write" FILE="#zipsourceurl#"
OUTPUT="#toBinary(securezipfile)#" addnewline="No">
<CFCONTENT TYPE="application/x-zip-compressed" FILE="#zipsourceurl#"
DELETEFILE="Yes">

Do you know what is wrong?

Thanks,

Nate

[Nate]

Maybe no responses because you are all too busy?

I still have no clue why the downloading is all of a sudden erroring
out with the error code I mentioned? Could it have to do with
replication? A change from a binary or image data type into a nText SQL
Server 7.0 data type? Permissions issue?

Thx,

Nate

[Nate]

The problem was that I needed to enable retrieval of long text in the
Cold Fusion 4.5 Administrator ODBC datasource configuration pages.
Remember to stop and start Cold Fusion services.

Everything is working great now!

-N