1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
    var sql = "SELECT id FROM streets WHERE territory_id = ? AND md5checksum = ?"
    JwApp.db.executeSql(sql, [JwApp.working_territory, street_md5], function (resultSet) {
      if (resultSet.rows.length) {
        street_id = resultSet.rows.item(0).id;
        
        for(var i = 0; i < resultSet.rows.length; i++) {
          results[resultSet.rows.item(i).id] = resultSet.rows.item(i);
        }
        
      }
      else {
      	console.log('No records returned.');
      }
    },
	function (error) {
            console.log('SELECT Street error: ' + error.message);
    });