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