[Solved] Saving XML response to SQLite and Parse using jquery

[Keen]

Hi
   I'm targeting iOS phone, I currently post a thread about SAVING XML to Local, I learned about Apache Cordova local Storage. But since there a size limit in 5mb and I'm having a large amount of data that I fetch in Web Service. I want to use SQLite. Is there a step-by-step tutorial of SQLite? and imagine "req" is the variable represent the XML response of Web Service. How to save it using SQLite and parse using Jquery? Thank you for who will response!

Thanks
Keen

[David Silveria]

Here's how to handle databases from Cordova:http://cordova.apache.org/docs/en/2.4.0/cordova_storage_storage.md.html#Database
You can check stackoverflow for answers as well e.g.: http://stackoverflow.com/questions/8375382/how-to-store-json-in-sqlite
http://stackoverflow.com/questions/12153857/how-can-i-insert-a-json-object-into-a-sqlite-table-in-javascript-phonegap-cord
https://groups.google.com/forum/?fromgroups#!topic/phonegap/EE7JzNN1MNI

[Keen]

Hi David,
 Thanks for the help. But using SOAP XML ,I can get the response and save the data using the SQLITE,as whole XML, but what I need is to parse the data from SQLite

[David Silveria]

Here is a thread about this: http://stackoverflow.com/questions/4935632/how-to-parse-json-in-javascript

It is much easier to find generic info by using google than waiting for someone else to point a reading to you.