WebSQL passing values in as parameter

Question

I am using Phonegap and I am following the guide on their site but it gives me this function.

function populateDB(tx) {
 tx.executeSql('DROP TABLE IF EXISTS DEMO');
 tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
 tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');
 tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
}
function errorCB(err) {
    alert("Error processing SQL: "+err.code);
}

function successCB() {
    alert("success!");
}

var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
db.transaction(populateDB, errorCB, successCB);

But how would I pass values as a parameter in there? Is it possible to do something like this?

function populateDB(tx, values) {
 tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
 tx.executeSql('INSERT INTO DEMO (id, data) VALUES (values['id'], values['data'])');
}

var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
db.transaction(populateDB(values), errorCB, successCB);

I saw that it is possible to work with question marks but I can't find a clear tutorial on it.

Did my answer provide a solution?

Ross
– Ross

2014-05-06 17:29:35 +00:00
Commented May 6, 2014 at 17:29 — Ross
– Ross, Commented May 6, 2014 at 17:29

Ross · Accepted Answer · 2014-05-07 14:12:28Z

2

I think this is what you're after -

var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
var insertValues = {
    values1: [1, 'First row'],
    values2: [2, 'Second row']
};

doInserts(insertValues);

function doInserts(insertValues) {
    db.transaction(function(tx) {
        tx.executeSql('DROP TABLE IF EXISTS DEMO');
        tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
        tx.executeSql(
            'INSERT INTO DEMO (id, data) VALUES (?, ?)', 
            insertValues.values1,
            insertSuccess,
            insertFail
        );
        tx.executeSql(
            'INSERT INTO DEMO (id, data) VALUES (?, ?)',
            insertValues.values2,
            insertSuccess,
            insertFail
        );
    });
}

function insertSuccess() {
    console.log('insert success');
}

function insertFail(err) {
    console.log('insertFail, err.message: ' + err.message);
}

This stuff is asynchronous so if you want to know when all your inserts are finished one trick that works is to -

Count the number of inserts you are expecting to do and store it in a variable.
When an insert is successful, decrement 1 on the variable storing the number of inserts expected.
When the variable holding the number of inserts expected is 0 then you know all your inserts have finished.

edited May 7, 2014 at 14:12

answered May 2, 2014 at 18:02

Ross

3,3301 gold badge22 silver badges18 bronze badges

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

2 Comments

Sinan Samet Over a year ago

It's not exactly what I was looking for sorry. What I meant was to pass the values in the function like populateDB(tx, values)

Ross Over a year ago

@SinanSamet I updated the answer, let me know if this is what you're wanting.

Collectives™ on Stack Overflow

WebSQL passing values in as parameter

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related