I have a sqlite database with one of the column as TIMESTAMP of type INT. This is the Node.js code for selecting the values greater than a particular value:
var pointer = 0;
sqlDB.serialize(function(){
sqlDB.each("SELECT * FROM Beacon23 where TIMESTAMP > pointer", function(err, row) {
//do something
});
I have to update the value of pointer after each transfer, so initially I declare it as 0. But upon execution of the code I get an error: TypeError: Cannot read property 'TIMESTAMP' of undefined.
Aucun commentaire:
Enregistrer un commentaire