CODEWITHSUNDEEP
javascriptnode.jssqlite
Megaman
Megaman

Reputation: 169

Preparing statement in Node js with SQLite3 for GET query

On the API page, it is written that statements can be use to do a GET query ([Link to the API])1 but I have tried to use it and I can't have a good result (the row is always undefined) Here is a sample of my code

var db = openDatabase();

db.serialize(function() {
    var stmt = db.prepare("SELECT * FROM table WHERE (?)=(?)");
    stmt.get(field,value,function(err,row){
        var callbckObj = null;

        if(row != undefined){
            callbckObj = new callbckObj(row);
        }
        callback(err, callbckObj);      
    });
    stmt.finalize();
});

db.close();

Thanks in advance

Upvotes: 1

Views: 2515

Answers (1)

Megaman
Megaman

Reputation: 169

Finally, the get statement can take only one parameter so the correct SQLITE query is :

db.serialize(function() {
    var stmt = db.prepare("SELECT * FROM table WHERE "+KEY_FIELD_NAME+"=(?)");
    stmt.get(fieldName,function(err,row){
        var callbckObj = null;

        if(row != undefined){
            callbckObj = new callbckObj(row);
        }
        callback(err, callbckObj);      
    });
    stmt.finalize();
});

db.close();

Upvotes: 2

Related Questions