title: sqlite query with ajax jQuery?
body: <p>I have a problem with using sqlite queries within back getJSON response function in my phonegap app.</p>
  
  <p>I tried to apply this code and all I have is the error </p>
  
  <blockquote>
    <p>INVALID_STATE_ERR: DOM Exception 11: An attempt was made to use an object that is not, or is no longer, usable.</p>
  </blockquote>
  
  <p>my code is</p>
  
  <pre><code>&lt;script&gt;
       document.addEventListener("deviceready", onDeviceReady, false);
       function onDeviceReady() {
          // open DB connection
           var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
           db.transaction(populateDB, errorCB, successCB);
      }
  
      function populateDB(tx) {
  
           tx.executeSql('DROP TABLE IF EXISTS buses');
           tx.executeSql('CREATE TABLE IF NOT EXISTS buses (bus_id INTEGER PRIMARY KEY,bus_no TEXT, bus_time TEXT,from_loc TEXT,to_loc TEXT,route TEXT)');
           $.getJSON('http://myegy.me/maryam/asem/api.php?table=trip', function(data) {
                $.each(data, function(key, val) {
  
                      tx.executeSql('INSERT INTO buses (bus_no,from_loc,to_loc,route) VALUES ("'+val['trip_number']+'","'+val['from_id']+'","'+val['to_id']+'","'+val['stop_station']+'")');
                });
              });
  
           tx.executeSql('DROP TABLE IF EXISTS bus_stations');
           tx.executeSql('CREATE TABLE IF NOT EXISTS bus_stations (id INTEGER PRIMARY KEY,station_name TEXT, station_description TEXT,station_lat TEXT,station_long TEXT)');
           $.getJSON('http://myegy.me/maryam/asem/api.php?table=station', function(data) {
                $.each(data, function(key, val) {
  
                      tx.executeSql('INSERT INTO bus_stations (station_name,station_lat,station_long) VALUES ("'+val['station_name']+'","'+val['latitude']+'","'+val['longitude']+'")');
                });
              });
  
      }
  
      &lt;/script&gt;
  </code></pre>
  
  <p>the problem in these two lines</p>
  
  <pre><code> tx.executeSql('INSERT INTO buses (bus_no,from_loc,to_loc,route) VALUES ("'+val['trip_number']+'","'+val['from_id']+'","'+val['to_id']+'","'+val['stop_station']+'")');
  </code></pre>
  
  <p>and</p>
  
  <pre><code>tx.executeSql('INSERT INTO bus_stations (station_name,station_lat,station_long) VALUES ("'+val['station_name']+'","'+val['latitude']+'","'+val['longitude']+'")');
  </code></pre>