HTML 5 SQLite: Multiple Inserts in One Transaction

Question

Is it possible to do something like this:

begin;
    insert into some_table (some_col, another_col) values ('a', 'b');
    insert into some_table (some_col, another_col) values ('c', 'd');
    ...
commit;

...in HTML 5?

With each transaction being async and having it's own callback, seems to me that it would be difficult to write a routine that inserts an unknown amount of rows, and then calls back when it has completed.

Answer 1

Why yes, yes there is indeed a way to do that!

If you had read the HTML5 Web Database spec, you would know that the executeSql method takes its own callback as a parameter. You would also know that each transaction also has its success and failure callbacks, just like each executeSql call, and that you can have as many executeSql calls in a transaction as you want.