How do I go about getting the last inserted (autoincremented) ID when writing to a WebSQL DB in Javascript for Phonegap?

I thought it may have been possible using the commented out snippet below.

Here is the structure of the table:

tx.executeSql('CREATE TABLE IF NOT EXISTS locations (id INTEGER PRIMARY KEY, lTitle TEXT, lDeleted INTEGER DEFAULT 0)');

And here is where I am writing the row to the table:

tx.executeSql(
            'INSERT INTO locations (lTitle) VALUES (?)',
            [$('#newLocation').val()],
            function(tx, results){
                //alert('Returned ID: ' + results.rows.item(0).id);
            },
            errorCB
        );

How do I go about getting the last inserted (autoincremented) ID when writing to a WebSQL DB in Javascript for Phonegap?

I thought it may have been possible using the commented out snippet below.

Here is the structure of the table:

tx.executeSql('CREATE TABLE IF NOT EXISTS locations (id INTEGER PRIMARY KEY, lTitle TEXT, lDeleted INTEGER DEFAULT 0)');

And here is where I am writing the row to the table:

tx.executeSql(
            'INSERT INTO locations (lTitle) VALUES (?)',
            [$('#newLocation').val()],
            function(tx, results){
                //alert('Returned ID: ' + results.rows.item(0).id);
            },
            errorCB
        );

• javascript
• sql
• cordova

1 Answer 1

I was close. This does the trick:

tx.executeSql(
            'INSERT INTO locations (lTitle) VALUES (?)',
            [$('#newLocation').val()],
            function(tx, results){
                alert('Returned ID: ' + results.insertId);
            },
            errorCB
        );