I am exporting to excel via html to get images out of a database (yep, images in excel…)
I am using the blobloader like this:
if (forms.export_dialog.fv_image == 1){
// v_raw_html += '<td height=13 align=right width=75> <img src = ' + 'media:///servoy_blobloader?servername=art&tablename=artworks&dataprovider=temp_image&mimetype=image/jpg&rowid1=' + foundset.getSelectedIndex() + '></html></td>'
var tableName = 'artwork'
var columnName = 'temp_image';
var id = i;
var mimeType = 'application/jpeg';
var fileName = reference_number;
var URL = 'media:///servoy_blobloader?servername=' + currentcontroller.getServerName()
URL += '&tablename=' + tableName;
URL += '&dataprovider=' + columnName;
URL += '&rowid1=' + id;
URL += '&mimetype=' + mimeType;
URL += '&filename=' + fileName;
v_raw_html += "<td><img src = \'" + URL + "\'></html></td>"
}
It is not working. I just get dead image icons for each row.
Any pointers on what I am doing wrong?
Thank you
Bevil