snipt

Ctrl+h for KB shortcuts

Text only

execute db

    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);
    });
https://snipt.net/embed/c4d85f21d90fd616c1a8497c99c86115/
/raw/c4d85f21d90fd616c1a8497c99c86115/
c4d85f21d90fd616c1a8497c99c86115
text
Text only
17
2019-07-15T19:54:24
True
False
False
Sep 04, 2016 at 11:25 PM
/api/public/snipt/147697/
execute-db
<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>
angular, ionic
--- 
+++ 
@@ -0,0 +1,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);
+    });