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.