I agree it adds extra load on the webserver and database and fills the
database.
Anyway here is the code to get the image back out.
<cfquery name="imageQuery" datasource="mssql">
select dataFile
from file
where id = 1
</cfquery>
<cfimage action="writetobrowser" source="#imageQuery.dataFile#" /> or
<cffile action="write" file="c:\imagefromdb.jpg"
output="#imageQuery.dataFile#" />
Paul.
On Fri, Feb 27, 2009 at 10:39 AM, Jacob <[email protected]> wrote:
>
> Agree... store image file location in database that points to the image on
> the server. From experience, better performance in my opinion. We had
> plenty of images to test it out... ;-)
>
> -----Original Message-----
> From: Paul Kukiel [mailto:[email protected]]
> Sent: Thursday, February 26, 2009 12:15 PM
> To: cf-talk
> Subject: Re: Convert Image to Binary
>
>
> Managing images on disk is a better way but if you must use the data base
> make sure you are using
>
> <cfqueryparam scfqltype="CF_SQL_BLOB"
> vale="#toBase64(FinalMergedDisclosure)# />
>
> Which should work for you.
>
>
> On Thu, Feb 26, 2009 at 11:14 AM, Priya Koya <[email protected]> wrote:
>
>>
>> <cfset thisDir = expandPath(".")>
>>
>> <cffile action="upload" fileField="image" destination="#thisDir#"
>> result="fileUpload"
>> nameconflict="overwrite">
>> <cfdump var="#thisDir#">
>> <cfimage action="read" source="#fileUpload.serverfile#"
>> name="myImage">
>> <cffile action="readBinary" file="#image#"
>> variable="FinalImage">
>> <br/>variable<cfdump var="#FinalImage#">
>> <!--- <cfset Image_Binary = "#toBinary(toBase64(FinalMergedDisclosure))#">
>> <cfdump var="#Image_Binary#"> --->
>> <cfquery name="Query4" datasource="Platform" result="result_1">
>> update table1 set Logo='#FinalImage#' where Name='John'
>> </cfquery>
>>
>> I am getting an error: ByteArray objects cannot be converted to strings.
>> I tried with tostring etc.. but didnt work
>> Datatype for this column is varBinary(MAX).
>>
>> Any sugestions....
>>
>> Thanks,
>> Priya.
>>
>>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319908
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
