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

ByteArray objects cannot be converted to strings... CFIMAGE

LEGEND ,
Feb 18, 2015 Feb 18, 2015

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,

^_^

1.8K
Translate
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

Did you enable the BLOB setting in your Coldfusion datasource?

Translate
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

BLOB and CLOB are both enabled.

^_^

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

Translate
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

What about this instead:

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

Translate
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
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,

^_^

Translate
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