Servoy 7.x.x Documentation
Child pages
  • servoy_blobloader
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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:

Blobloader 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() + '&tablename=' + tableName + '&dataprovider=' + columnName + '&rowid1=' + id +'&mimetype=' + mimeType +'&filename=' + fileName;
return '<html><body><a target="_blank" href="'+URL+'">test</a></body></html>';

Combined 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.

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

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

  • No labels