Copy link to clipboard
Copied
Hello, everyone,
I'm working on a project that another developer created many moons ago. I'm attempting to SELECT a blob from an Oracle db, and use CFIMAGE action="writeToBrowser" to display the image.
<CFIMAGE action="writeToBrowser" source="#qry.IMAGEDATA#" format="png" />
It's giving me the error message "ByteArray objects cannot be converted to strings". The datatype IS "BLOB", not varchar.
I'm running CF10 update 15 on a Windows7 system, with Oracle 11g. Am I missing a step, somewhere?
V/r,
^_^
Copy link to clipboard
Copied
Did you enable the BLOB setting in your Coldfusion datasource?
Copy link to clipboard
Copied
BLOB and CLOB are both enabled.
^_^
UPDATE: And the memory for both has been increased x100.
Copy link to clipboard
Copied
What about this instead:
source="#imageNew(qry.IMAGEDATA)#"
Copy link to clipboard
Copied
Ah.. hmm.. hadn't thought of that, actually. When I can, I'll give that a shot and report back. Thank you!
V/r,
^_^