• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

ByteArray objects cannot be converted to strings... CFIMAGE

LEGEND ,
Feb 18, 2015 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.6K

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
community guidelines
Advocate ,
Feb 19, 2015 Feb 19, 2015

Copy link to clipboard

Copied

Did you enable the BLOB setting in your Coldfusion datasource?

Votes

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
community guidelines
LEGEND ,
Mar 02, 2015 Mar 02, 2015

Copy link to clipboard

Copied

BLOB and CLOB are both enabled.

^_^

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

Votes

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
community guidelines
Community Expert ,
Mar 07, 2015 Mar 07, 2015

Copy link to clipboard

Copied

What about this instead:

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

Votes

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
community guidelines
LEGEND ,
Mar 09, 2015 Mar 09, 2015

Copy link to clipboard

Copied

LATEST

Ah.. hmm.. hadn't thought of that, actually.  When I can, I'll give that a shot and report back.  Thank you!

V/r,

^_^

Votes

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
community guidelines
Resources
Documentation