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);
    });

<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a> var sql = &quot;SELECT id FROM streets WHERE territory_id = ? AND md5checksum = ?&quot; </span><span id="L-2"><a name="L-2"></a> JwApp.db.executeSql(sql, [JwApp.working_territory, street_md5], function (resultSet) { </span><span id="L-3"><a name="L-3"></a> if (resultSet.rows.length) { </span><span id="L-4"><a name="L-4"></a> street_id = resultSet.rows.item(0).id; </span><span id="L-5"><a name="L-5"></a> </span><span id="L-6"><a name="L-6"></a> for(var i = 0; i &lt; resultSet.rows.length; i++) { </span><span id="L-7"><a name="L-7"></a> results[resultSet.rows.item(i).id] = resultSet.rows.item(i); </span><span id="L-8"><a name="L-8"></a> } </span><span id="L-9"><a name="L-9"></a> </span><span id="L-10"><a name="L-10"></a> } </span><span id="L-11"><a name="L-11"></a> else { </span><span id="L-12"><a name="L-12"></a> console.log(&#39;No records returned.&#39;); </span><span id="L-13"><a name="L-13"></a> } </span><span id="L-14"><a name="L-14"></a> }, </span><span id="L-15"><a name="L-15"></a> function (error) { </span><span id="L-16"><a name="L-16"></a> console.log(&#39;SELECT Street error: &#39; + error.message); </span><span id="L-17"><a name="L-17"></a> }); </span></pre></div> </td></tr></table>