in www/sql/index.js [90:112]
var readDatabase = function(index) {
var db = dbs[index];
if (!db) {
db = dbs[index] = openDb(index);
if (!db) {
return;
}
}
db.transaction(function (tx) {
tx.executeSql('SELECT * FROM DEMO WHERE id=2', [], function (tx, results) {
var len = results.rows.length;
var text = "DEMO table: " + len + " rows found.<br>";
text = text + "<table border='1'><tr><td>Row</td><td>Data</td></tr>";
for (var i=0; i<len; i++){
text = text + "<tr><td>" + i + "</td><td>" + results.rows.item(i).id + ", " + results.rows.item(i).data + "</td></tr>";
}
text = text + "</table>";
databaseOutput(text);
}, function(tx, err) {
alert("Error processing SELECT * WHERE id=2 SQL: "+err.message);
});
});
}