...
Code Block |
---|
title | 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=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 |
---|
title | Combined primary key |
---|
|
In case of a PK buildup out of multiple columns, add &rowid2=value ... &rowidXX=value |
Code Block |
---|
title | 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=' +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