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