Running sqlite3 query in node.js returns `undefined` rows with no error

Question

Using Node.js 4.2.1 with sqlite3 3.1.1 The following code -

var sqlitedb = new sqlite3.Database(sqliteFilename);
sqlitedb.serialize(function() {

   sqlitedb.run("SELECT ZDATA FROM ZMYTABLE;", function(err, rows) {
      console.log(rows);
   });

});
sqlitedb.close();

Prints undefined in the console, but if the same query is executed using the sqlite3 tool, it works fine -

$ sqlite3 backup.sqlite 
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> SELECT ZDATA FROM ZMYTABLE;
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
...

Any idea why SQL returns undefined rows in Node.js?

Have you tried removing the semicolon from the query string? I wouldn't expect it to cause an error, but it shouldn't need to be there. — Jared Dykstra
– Jared Dykstra, Commented Nov 10, 2015 at 22:07
Can you include some of your table data and structure so it's testable? — Andrius
– Andrius, Commented Nov 11, 2015 at 7:11

Andrius · Accepted Answer · 2015-11-16 08:06:54Z

9

+50

The method run() does not return a value and in the callback, only returns an error if one occurred.

To fetch data, you should use get() or all().

This will work perfectly:

sqlitedb.serialize(function() {
   sqlitedb.get("SELECT ZDATA FROM ZMYTABLE;", function(err, rows) {
        console.log(err);
        console.log(rows);
   });
});

answered Nov 16, 2015 at 8:06

Andrius

5,94922 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kostya · Accepted Answer · 2015-11-11 10:07:15Z

0

sqlite3 3.1.1 is not supporting Node.js 5.0.0. We should wait update of sqlite3.

answered Nov 11, 2015 at 10:07

Kostya

1

2 Comments

Kof Over a year ago

It also happens in Node.js 4.2.1.

Tomasz Jakub Rup Over a year ago

The sqlite3 module works with Node.js v0.10.x, v0.12.x, v0.4.x, and v0.5.x.

Collectives™ on Stack Overflow

Running sqlite3 query in node.js returns `undefined` rows with no error

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related