Forum Stats

  • 3,851,702 Users
  • 2,264,013 Discussions
  • 7,904,820 Comments

Discussions

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

marian_man
marian_man Member Posts: 33
edited Mar 3, 2017 7:46AM in APEX Discussions

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)

photo1.png

photo2.png

Tagged:

Answers

This discussion has been closed.