INSERT INTO DATABASE
I am trying to insert a new client into a database. I have used Jquery to get an array of all the elements of the form.
What i can't figure out is the best way to pull the elements from the array and insert the new entry into the database.
Any suggestions would be appreciated.
Trent
1 Answer
-
You can look in the API guides, and download the latest version of those (at the bottom you will find the database guide:
[inline]http://developer.appcelerator.com/doc/reference_guides[/inline]A simple way to insert in your database is:
coldDB.execute('INSERT INTO coldBeverages (beverage,value2) VALUES(?,?)', 'Juice,'Second value');