BLOB [solved]



  • 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;
    }
    @



  • 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/����@


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.