Return a variable from a WebSQL Javascript command

Question

I'm trying to query a WebSQL database using Javascript to return the value of the 'id' column for the single highest data line.

db.transaction(function(tx) {
   //
   // PROBLEM AREA
   // How to get the data into a variable?
   //

   var xyz = 0;

   tx.executeSql('SELECT MAX(id) FROM WORKOUTS ORDER BY id DESC' [],function(tx, results) {
     var xyz = results.row.id, i;
     alert('Alert 2');
     alert(xyz);
   });

}, function(){
    alert('success SELECTING!');
}); // End transaction

I believe the query is executing as I am getting the success SELECTING alert. The alert(xyz) is simply returning value nil.

How can I get the data from the SQL database into a Javascript variable?

Thanks!

EDIT: The following suggested code change results in a ReferenceError: Can't find variable: results

function myTransaction(cb)
{
    db.transaction(function(tx) {
        tx.executeSql('SELECT MAX(id) FROM WORKOUTS ORDER BY id DESC', [], function(tx, results) {
        cb(results); }); 
    },function(){
        alert('success SELECTING!');
    }); // End transaction
}

myTransaction(function(results) { alert(results); });

function myTransction(cb) { db.transaction(function(tx) { var xyz = 0; tx.executeSql('SELECT MAX(id) FROM WORKOUTS ORDER BY id DESC' [], function(tx, results) { cb(results); }); }) } myTransction(function(results) { console.log(results); }); — Rayon
– Rayon, Commented Mar 13, 2016 at 16:54
Rayon - thanks for your help. Unfortunately that code still isn't doing what I was hoping it would. It's returning a ReferenceError: Can't find variable: results in the console. I will edit the main post to reflect the adjusted code. — Wayne
– Wayne, Commented Mar 13, 2016 at 17:14

tschaible · Accepted Answer · 2016-03-13 17:22:40Z

2

A few things to note:

You're missing a comma in your executeSql parameter list

tx.executeSql('SELECT MAX(id) FROM WORKOUTS ORDER BY id DESC', [],function(tx, results) {

NOT

tx.executeSql('SELECT MAX(id) FROM WORKOUTS ORDER BY id DESC' [],function(tx, results) {

The results object contains a rows attribute, not a row.

So you want to use

results.rows.item(0)

NOT

results.row

transaction() takes 3 callbacks, the first is the callback which will be executed when the transaction is opened. The second is the error callback and the third is the success callback. You're using the error callback but treating it like a success callback.

edited Mar 13, 2016 at 17:22

answered Mar 13, 2016 at 17:12

tschaible

7,6951 gold badge33 silver badges35 bronze badges

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

1 Comment

Wayne Over a year ago

Interesting tschaible - so my success selecting is in fact not successful? All my notes here suggested I was doing that bit right! That's unfortunate as I have a query before this that is also not working then.

Collectives™ on Stack Overflow

Return a variable from a WebSQL Javascript command

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related