1. 

   serge lorich, Member

   Good day to you!

   I have files stored in my database's BLOBs.
   How can i make table with links or buttons to download BLOBs as files?
2. 

   myDBR Team, Key Master

   Blob support is now image only. Downloadable blobs require a bit different handling. We can put it in feature request list.

   --
   myDBR Team
3. 

   Fadi Nofal, Member

   Dear myDBR Support,

   could you please give us a example to display blob images within report

   Regards
4. 

   myDBR Team, Key Master

   If you have an image as a blob in the database, you can use a columnstyle to define it as a blob and give it optional styles:

   1.select 'dbr.colstyle', 'image_data, '[width:150px]image';

   2. 

   3.select image_data

   4.from blobtest;

   If the image is stored as base64 encoded, you can use it in an IMG tag:

   1.select id, concat('dbr.html:<img src="image/png;base64,',image_data, '">') as 'image_data'

   2.from base64;

   --
   myDBR Team
5. 

   Fadi Nofal, Member

   Thank you for countinous support ...

Reply

You must log in to post.