Hi folks, Here's the scoop,
System info: CFMX Prof. Edition on WinXP Prof. machine accesses a remote Oracle8 Database on Win2K Prof machine; the datasource connection has been tested to work; CLOB enabled; Long Text Buffer (chr) is set to 64000; Allowed SQL: SELECT and SP. DB info: The Oracle table's CLOB column stores binary image file, which has been converted to Base64 presentation with ToBase64 function before insertion; the images size are all less than 64k; No problem with CF5 while Prob desc for CFMX: When the CLOB data is retrieved and attempted to be converted back to original binary format with toBinary function, CFMX throws an err, "The parameter 1 of function ToBinary, which is now "/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJC .. (omitted) h86A3+N+s7v49/KQpyafj9jwoG/x/0dz8f/2Q==" must be a Base-64 encoded string." Hmmm, what's going on? Thanks. DL __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.