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