Help with Javascript SQL INSERT

javascript sqlite webos enyo
levi picture levi · Jul 26, 2011 · Viewed 7.3k times · Source

I have the following code which inserts a "task" into a table with a value for the "task". I am trying to modify this statement to insert multiple values into multiple columns, but I cant seem to get it to work since I am unfamiliar with the format.

Can sombody show me how the can be modified to insert multiple values? 

var item  = this.$.newItem.getValue();
this.$.db.query( 'INSERT INTO tasks ( task ) VALUES ( ? )', { values: [ item ] } );

Thanks alot.

Answer

diagonalbatman picture diagonalbatman · Jul 26, 2011

I am assuming you didn't mean to tag this MySQL....

However - a useful class for helping out with Enyo DB queries is:

https://github.com/onecrayon/database-webos

One crayon's implementation. Works very nicely for Enyo.

Related questions

Is it possible to access an SQLite database from JavaScript?

I have a set of HTML files and a SQLite database, which I would like to access from the browser, using the file:// scheme. Is it possible to access the database and create queries (and tables) using JavaScript?

Read More
Sqlite in chrome

Is it possible to make chrome extension that interacts with sqlite database similarly as firefox extension? Could you give me some advise or link where is more info about developing chrome extension interacting with sqlite? thank you

Read More
SQLite database in Javascript locally

I'm using a PhoneGap project on XCode. I am trying to connect to a SQLite databse by using Javascript. I have made a file "myDatabase.sqlite" in an SQLite tool. Now my question is how do I open that database …

Read More