Getting Results from a Web SQL database

Posted by andrew8088 on Stack Overflow See other posts from Stack Overflow or by andrew8088
Published on 2010-04-24T16:50:57Z Indexed on 2010/04/24 16:53 UTC
Read the original article Hit count: 124

Filed under:

I'm playing around with the new Web SQL databases. Is there a way to return results from a SELECT statement? Here's my example:

function getTasks (list) {
  db.transaction(function (tx) {
   list = list || 'inbox';
   tx.executeSql("SELECT * FROM tasklist WHERE list = ?", [list], function (tx, results) {
    var retObj = [], i, len = results.rows.length;
    for ( i = 0; i < len; i++ ) {
     retObj[i] = results.rows.item(i);
    }
    return retObj;
   });
  });
 }

The getTasks function is returning before the success callback does; is there a way to get the results out of the executeSql method, or do I have to do all the processing within the callback?

© Stack Overflow or respective owner

Related posts about JavaScript