Highlighted

ByteArray objects cannot be converted to strings... CFIMAGE

LEGEND ,
Feb 18, 2015

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,

^_^

Views

1.1K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

ByteArray objects cannot be converted to strings... CFIMAGE

LEGEND ,
Feb 18, 2015

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,

^_^

Views

1.1K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Feb 18, 2015 0
Advocate ,
Feb 19, 2015

Copy link to clipboard

Copied

Did you enable the BLOB setting in your Coldfusion datasource?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 19, 2015 0
LEGEND ,
Mar 02, 2015

Copy link to clipboard

Copied

BLOB and CLOB are both enabled.

^_^

UPDATE:  And the memory for both has been increased x100.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 02, 2015 0
Adobe Community Professional ,
Mar 07, 2015

Copy link to clipboard

Copied

What about this instead:

source="#imageNew(qry.IMAGEDATA)#"

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 07, 2015 0
LEGEND ,
Mar 09, 2015

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,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 09, 2015 0