Querying SQLite existing database using jQuery

Hi there,

I've a existing already populated that I want to query and display result. Here is my code and it is not working:
http://plnkr.co/edit/XiAAPdiOj9A1YpYuDTwe?p=preview

I'm getting uncaught ReferenceError: refreshtest is not defined index.html:209. that is for line

gettest( refreshtest );

I saw examples and in most of the examples, after opening the database, table is created and data is inserted by using a form. Then queried. But I have already populated database, so I don't need to create table or populate it. The size of the database is only 8 KB but in my code I used a large number. In my case user will select either drop down and click Search Database and I want to display result on the db_result page.

I've a few questions:

I came across a posting that says it's not possible to use already posting where someone said it is not possible to access existing database http://stackoverflow.com/questions/15680278/connecting-to-an-existing-sqlite-db-with-javascript. Is this true? My database has 4 tables and it's not a huge database. If this is true, I'll have to create 4 tables and populate them every time app is launched.

Since Chrome allows using SQLite database, in the Developer Tools, under Resources I see database called demo but it is empty, I don't see my table nor data? I put my database file in this folder C:\Users\joe\AppData\Local\Google\Chrome\User Data\Default\databases

In iOS app, where is SQLite database file is stored?

If you want I can provide you my database that I'm using.

Thanks a bunch for your time and help in advance.

Joe Green

Topic Participants
tusharmedhi
jtara-jquery

Querying SQLite existing database using jQuery

Querying SQLite existing database using jQuery

Topic Participants

tusharmedhi

jtara-jquery