title: Unable to display SQLite data as listview using phonegap
body: <p>The function <code>get_list()</code> here is able to execute the query but not able to display the rows.</p>
  
  <pre><code>function get_list()
  {
      db = window.openDatabase("timeDB", "1.0", "time", 200000);
      db.transaction(populateDB, transaction_error, populateDB_success);   
  
      function populateDB(tx)
      {
          tx.executeSql("SELECT (date) FROM time", [], function (tx, res)
          {            
              var len = result.rows.length;
  
              if (len &gt; 0)
              {
                  for (var i = 0; i &lt; len; i++)
                  {
                      var a = results.rows.item(i)['date'];
                      document.getElementById("output").value = a;
                  }
              }
          });
      }
  
      function transaction_error(tx, error)
      {
          alert("Database Error: " + error);
      }
  
      function populateDB_success()
      {
          alert("Successfully inserted");
      }
  }
  </code></pre>
  
  <p>The function <code>get_list()</code> is working when the code to display the rows is removed. I have already looked through other examples.</p>