Hello,
I am trying to create a "List View" using the "jQuery Mobile Smartphone" User Interface. The images do not show. I get two columns both showing the text value in the column defined as the "Text Column". I have the images stored in a table as blobs. They are .png images 80x80 and display just fine under a test page I did using a classic report and the "Desktop" User Interface. I have also tried .jpg files. I also have tried all four options for "Image Type"
The "List View" Region is defined as:
Region Source:
with DOTS as (
select 12 as DOT_UID,'Item 1' as DOT_NAME,90 as GREEN,70 as YELLOW,70 as RED, 1 as CURRENT_DOT from dual
union
select 13,'Item 2',90,70,70,1 as CURRENT_DOT from dual
union
select 15,'Item 3',90,70,70,1 as CURRENT_DOT from dual
union
select 17,'Item 4',101,90,80, 3 as CURRENT_DOT from dual
union
select 22,'Item 5',95,85,85,1 as CURRENT_DOT from dual)
select
D.DOT_UID,
D.DOT_NAME,
D.GREEN,
D.YELLOW,
D.RED,
D.CURRENT_DOT,
I.IMAGE_UID,
I.IMAGE_SMALL,
dbms_lob.getlength("IMAGE_SMALL") as IMAGE_SMALL_2
from
DOTS D,
SYNKDOT_IMAGE I
where
D.CURRENT_DOT = I.IMAGE_UID;
Region Attributes:
Settings
Features
Advanced Formatting = NULL
Show Image = CHECKED
Show List Divider = NULL
Has Split Button = NULL
Enable Search = NULL
Is Nested List View = NULL
Inset List = NULL
Text Column = DOT_NAME
Supplemental Information Column = NULL
Counter Column = NULL
Image Type = Image stored in BLOB
Image BLOB Column = IMAGE_SMALL
Image Primary Key Column 1 = IMAGE_UID
Image Primary Key Column 2
Link Target = NULL
I am running on:
Application Express 4.2.1.00.08
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Viewing the "List View" on:
FireFox 30.0
iOS Safari
Any help you can give me would be great. I have been researching and tiring many different this with no luck. I hope it is something simple I am just not seeing.
Message was edited by: Sky13. I added information about image sizes and types tried.