how to display image via 'display image' item, using SQL?

marian_man

Hi

how can I display image via 'display image' item?

the image is stored as BLOB in my database table, that can be retrieved as

SELECT PHOTO FROM EMPLOYEES WHERE ID_EMPLOYEE = ...

but this does not seem to work , or I don't know where to put this SQL query?,

because there are two available fields: in SETTINGS | Based on SQL statement,

or in SOURCE | SQL Query (return single value)  ?

(see attached)

LA County APEX

Type = PHOTO

Used = Always, replacing...

marian_man

update:

I tried the trick with

SELECT dbms_lob.getlength(PHOTO)

FROM EMPLOYEES

WHERE ID_EMPLOYEE = ...

but still doesn't work...

btw. I can reproduce - displaying photos in a static report described here

Brendan Tierney - Oralytics Blog: How to Display a BLOB image in an APEX Report

that is also usable, except that I don't know how to set some "fixed size" to the cell /'cell width' column attribute doesn't work/

LA County APEX

I would suggest that you create an application on OTN first.

Mint-Innit

I have literally just done this today, and as far as I can see you've done it correctly, assuming your photo column really is an image blob. My SQL is in the 'settings' SQL Statement & is almost identical to yours. I haven't changed anything in the 'source' section from the defaults.

Oh, and I set the width in 'Custom Attributes' using: width="150"  

Cheers/

Er.RJ

Hi,

You should use

Based On -> Blob column return Sql Statement

& write your query below that in

SQL statment -> SELECT PHOTO FROM EMPLOYEES WHERE ID_EMPLOYEE = ...

Hope this will solve your problem.

Do let me know after do try this.

Thank you.

marian_man

thank you all!,

I figured out that on blank new page it actually works!...

(it doesn't work in one of my particular page, so probably there is some other bug... but I leave it for later now)

thanks