Save query result in a variable node.js and sqlite3
Publicado por Estudio (2 intervenciones) el 29/09/2016 13:56:30
I want to save query result in a variable using node.js and sqlite3, my code is like this:
But doesn't work... Somebody know how can I do that? Thanks in advance;
Best regards.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
var a=0;var b=0;stmt = db.prepare("select var1, var2 from my_table where count = ?");
stmt.bind(my_count);
stmt.get(function(error,row){
if(error){
throw err;
} else{if(row){
console.log(row.var1); //result is 6
console.log(row.var2); // result is 7
a=row.var1;
b=row.var2;
} }});
console.log(a); //result is 0
console.log(b); // result is 0
But doesn't work... Somebody know how can I do that? Thanks in advance;
Best regards.
Valora esta pregunta
0