Servoy 7.x.x Documentation
Child pages
  • servoy_blobloader

Versions Compared

Old Version 10

changes.mady.by.user Paul Bakker

Saved on

compared with

New Version Current

changes.mady.by.user Paul Bakker

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

The Servoy Blobloader provides a convenient way to access files stored in a database column or a global variable and use it as if it were part of the Servoy Media library.

The Servoy Blobloader is a media URL, with arguments indicating where to retrieve the file from:

Code Block
titleBlobloader syntax to retrieve from the database
var tableName = 'filestoragetable';
var columnName = 'thefile';
var id = 1;
var mimeType = 'application/pdf';
var fileName = 'myFileName';
var URL = 'media:///servoy_blobloader?servername=' + currentcontroller.getServerName() 
URL += '&tablename=' + tableName;
URL += '&dataprovider=' + columnName;
URL += '&rowid1=' + id;
URL += '&mimetype=' + mimeType;
URL += '&filename=' + fileName;
return '<html><body><a target="_blank" href="'+URL+'">test</a></body></html>';
Note
titleCombined primary key

In case of a PK buildup out of multiple columns, add &rowid2=value ... &rowidXX=value. The PK values should be ordered by their name ascending.

Code Block
titleBlobloader syntax to retrieve from a global variable
var globalName = 'myGlobal';
var mimeType = 'application/pdf';
var fileName = 'myFileName';
var URL = 'media:///servoy_blobloader?global=' + globalName;
URL += '&mimetype=' + mimeType;
URL += '&filename=' + fileName;
return '<html><body><a target="_blank" href="'+URL+'">test</a></body></html>';

The Blobloader url can, for example be used in HTMl Area's to display images stored in the database or to provide a clickable downloadlink for the file in the Web Client.

In the other situation, the mimetype indicates the browser what the type of file is. The browser might use it to open the file in the appropriate application. The filename is suggested to the user when saving the file from the browser.

Note

For more information about mime types, see w3schools.com on mimetypes