BLOB [solved]
-
wrote on 28 Jun 2013, 22:09 last edited by
I'm using javascript to pull items from a db. I can grab all the text I want but when I try to get a BLOB from an image I get and error
Do I have to do something special to the var for the BLOB image?
@
QML Image: Cannot open: file:///Users/jon/Desktop/QML_test/����
@
Here is the code I'm using to get the text and the BLOB that's being a pain in my ass.@
db.transaction(
function(tx) {
var rs = tx.executeSql('SELECT * FROM mydb');
r=""switch (b){ case "title": r += rs.rows.item(a).title break; case "actor": r += rs.rows.item(a).actor break; case "director": r += rs.rows.item(a).director break; case "genre": r += rs.rows.item(a).genre break; case "rating": r += rs.rows.item(a).rating break; case "detail": r += rs.rows.item(a).detail break; case "image": // my BLOB image r += rs.rows.item(a).image break;}
})
return r;
}
@ -
wrote on 29 Jun 2013, 13:38 last edited by
Do you really save you image blob into the database or simply the image path ?
@QML Image: Cannot open: file:///Users/jon/Desktop/QML_test/����@
1/2