APEX 24.1 , FOEX 22.2.0.2 Latest.
Images are not displaying because the image tags are treated as normal text
SELECT IMAGE_ID
, PRIORITY
, '<img alt="' ||apex_escape.html_attribute(full_img)
||'" title="'||apex_escape.html_attribute(full_img)
||'" style="border: 1px solid #CCC; -moz-border-radius: 1px; -webkit-border-radius: 1px;" '
||'src="'||V('APP_IMAGES')||full_img
||'"'
||' height="120" width="180" class="thumbnail" />' IMG_SMALL
, FULL_IMG
, CREATED_AT
FROM IMAGE
ORDER BY PRIORITY
Now this always used to work fine
This is the result
Inspecting
"<img alt="/villas/mauritius/4882/b36785990b83fdad09223b6d44abf9b5_full.jpg" title="/villas/mauritius/4882/b36785990b83fdad09223b6d44abf9b5_full.jpg" style="border: 1px solid #CCC; -moz-border-radius: 1px; -webkit-border-radius: 1px;" src="/vg/villas/mauritius/4882/b36785990b83fdad09223b6d44abf9b5_full.jpg" height="120" width="180" class="thumbnail" />
So the " creates havoc and I have no idea how to get rid of it
My XTemplate is very simple
<div class="card">
<div>{IMG_SMALL}</div>
</div>