2. PHPRunner General questions
  3. SQL Views and showing images
This topic is locked

SQL Views and showing images

 		11/9/2021 8:52:06 PM
PHPRunner General questions
L
 LandonH author

I have an SQL view that union all on 6 tables.
These tables contain attachments and images.
In the orginal table you can select to see them etc.
In the SWL view you can see the attachment name or image name but not able to open it.
The link to the source im guessing in not their.

Is ther away to have the unioned records show the images etc in the sql view.

Thanks
Landon
admin 11/9/2021

No, it is not really possible. To show an image you need to select a primary key column in PHPRunner but in case of a UNION you may have duplicate values in that column.