title: WebSQL, Phonegap. Return the ID of the last inserted row
body: <p>How do I go about getting the last inserted (autoincremented) ID when writing to a WebSQL DB in Javascript for Phonegap? </p>
  
  <p>I thought it may have been possible using the commented out snippet below.</p>
  
  <p>Here is the structure of the table:</p>
  
  <pre><code>tx.executeSql('CREATE TABLE IF NOT EXISTS locations (id INTEGER PRIMARY KEY, lTitle TEXT, lDeleted INTEGER DEFAULT 0)');
  </code></pre>
  
  <p>And here is where I am writing the row to the table:</p>
  
  <pre><code>tx.executeSql(
              'INSERT INTO locations (lTitle) VALUES (?)',
              [$('#newLocation').val()],
              function(tx, results){
                  //alert('Returned ID: ' + results.rows.item(0).id);
              },
              errorCB
          );
  </code></pre>