0 Replies Latest reply: Nov 24, 2014 8:48 AM by Dewald van Staden RSS

    Help with Binary Object display

      Good day

       

      I have the following issue:

       

      I have a MySQL dbase with four tables.

      1st table (core) contains the main information about the row content, with a primary key named URI

      2nd table (image_blb) contains the topleveluri (foreign key) to the core table, also contains the column value, which contains the BLOB (Binary Library Object)

      3rd table (image2_blb) contains the topleveluri (foreign key) to the core table, also contains the column value, which contains the BLOB (Binary Library Object)

      4th table (image3_blb) contains the topleveluri (foreign key) to the core table, also contains the column value, which contains the BLOB (Binary Library Object)

       

      Now the problem that I am faced with, is that when I use the following script:

      ODBC CONNECT TO MySQL_CLICK_64Bit

       

      [IMG1_BLB]:

      SQL SELECT

          `_TOP_LEVEL_AURI` as '_URI',

          VALUE as IMG1

      FROM `dbase`.`image1_blb`;

       

      //-------- Start Multiple Select Statements ------

      INFO SELECT VALUE as IMG1,

        VALUE

        FROM `dbase`.`image1_blb`;

      //-------- End Multiple Select Statements ------

       

      The above listed query works 100% fine for table (image1_blb) to display each image that corresponds to the selected ID (URI).

       

      But when I duplicate that above statement for table (image2_blb) only the first image is displayed, irrelevant of the selection changes of the ID (URI).

       

      On the front end using a Text Object, set to display Image, and using the expression =info(IMG1)

       

      Any help regarding this would be greatly appreciated.