anyone test inserting a blob into an Oracle DB via CFMX? Supposedly this works now but I'm getting an error message:
"[Oracle JDBC Driver] The hexadecimal string is invalid" SQL is INSERT INTO foo (ct, bob) VALUES ( '55', <cfqueryparam cfsqltype="CF_SQL_BLOB" value="#tmp#">) where tmp is a Word doc grabbed via CFFILE. Cheers! -- Douglas Knudsen Alltel Corporate CIS Group 678-351-6063 "Spoon feeding in the long run teaches us nothing but the shape of the spoon." - E.M. Forster ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
