Now I can sucessfully store the Binary data to thedatabase but unable to retreive it. Again it is giving me with the same error.
I used <cfcontent> but sometimes its display and sometimes its not. Also tried sing toString,tobase64 etc.... but no results. Any ideas....? On Thu, Feb 26, 2009 at 9:11 PM, Paul Kukiel <[email protected]> wrote: > > <cffile action="readbinary" file="/store/image.jpg" > variable="fileContents"> > <cfqueryparam cfsqltype="cf_sql_blob" value="#fileContents#" /> > > Is all you need when the datatype is image or varbinary on MSSQL you > don't need the tobase64 that will teach me for responding to fast. > Thanks james > > You also need to check : -- Enable binary large object retrieval > (BLOB). in CF admin. > > On Thu, Feb 26, 2009 at 9:14 PM, James Holmes <[email protected]> > wrote: > > > > That would mean you're entering base64 text into a binary field. > > > > mxAjax / CFAjax docs and other useful articles: > > http://www.bifrost.com.au/blog/ > > > > > > > > 2009/2/27 Paul Kukiel <[email protected]>: > > > > > > 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. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
