Servoy 2020 Documentation
Child pages
  • servoy_blobloader

Versions Compared

Old Version 3

changes.mady.by.user Paul Bakker

Saved on

compared with

New Version 4

changes.mady.by.user Paul Bakker

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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() + '&tablename=XXXXX' + tableName + '&dataprovider=YYYYY' + columnName + '&rowid1=' + ZZZZZid +'&mimetype=' +AAAAA mimeType +'&filename=' +BBBBBB 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

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 + '&mimetype=' +AAAAA mimeType + '&filename=' +BBBBBB fileName;
return '<html><body><a target="_blank" href="'+URL+'">test</a></body></html>';

Where:

...

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