Skip to Main Content

Mobile Application Problem with Images In List View

Sky13Jul 2 2014 — edited Jul 18 2014

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.

Comments
Post Details
Added on Jul 2 2014
3 comments
1,481 views