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:319903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
