[thelist] Can Cold Fusion Write A binary file from a BLOB field

Jon Hall jonhall at ozline.net
Tue Nov 6 17:18:14 CST 2001

This hasn't been true since CF 4.5. What you need to do though is store the
binary file in the database as base64 encoded data. Once you query out the
data use tobinary() to convert it to a binary object in memory. Cffile will
let you write the variable to a file just like you would normally.

In order to read a binary file with cffile there is a seperate action
<cffile action="readbinary" ...>

----- Original Message -----
From: "Susan Wallace" <susanhw at webcastle.com>
To: <thelist at lists.evolt.org>
Sent: Tuesday, November 06, 2001 2:18 PM
Subject: Re: [thelist] Can Cold Fusion Write A binary file from a BLOB field

> Hi Matt,
> <CFFILE Action="write"> is only intended to write a text format file. To
> knowledge, the only way to accomplish this would be to write your own CFX
> tag that would take your data and write it to the type of file you need.
> In case you haven't thought in this direction, you might be able to find a
> utility that will take information in the form of a variable and then
> it to a file that you need. You could then run that Utility on the server
> using <CFEXECUTE>
> I have not done this, and not positive it would work, just a thought...
> Susan
> >We are taking data out of a SQL server that is a BLOB field and need to
> >write it to a binary file.
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list