{"absolute_url": "/jbmckee/javascript-promise/", "blog_post": false, "code": "      var sql = \"SELECT * from addresses\";\n      new Promise(function (resolve, reject) {\n        JwApp.db.executeSql(sql, [], function (resultSet) {\n          console.log('Length: '+resultSet.rows.length);\n\n          for(var i = 0; i < resultSet.rows.length; i++) {\n            results[resultSet.rows.item(i).id] = resultSet.rows.item(i);\n          }\n\n          console.log(results);\n          resolve(results);\n        }, function(error) {\n          console.log('SELECT error: ' + error.message);\n          reject(error.message);\n        })\n      })\n      .then(function (res) {\n        console.log('Execuited Then');\n        console.log(res);\n      })\n      .catch(function (res) {\n        console.log('Execuited Then Reject');\n        console.log('SQL error: '+res);\n      });\n", "created": "2016-12-14T14:07:28.938624", "description": "", "description_rendered": "", "embed_url": "https://snipt.net/embed/b8f84e331691e27497e9da6248bc4b86/", "full_absolute_url": "/jbmckee/javascript-promise/", "id": 147698, "lexer": "text", "line_count": 25, "log_entries": [], "meta": "", "modified": "2026-04-27T11:56:36.172528", "publish_date": null, "raw_url": "/raw/b8f84e331691e27497e9da6248bc4b86/", "resource_uri": "/api/public/snipt/147698/", "slug": "javascript-promise", "stylized": "<table class=\"highlighttable\"><tr><td class=\"linenos\"><div class=\"linenodiv\"><pre><a href=\"#L-1\"> 1</a>\n<a href=\"#L-2\"> 2</a>\n<a href=\"#L-3\"> 3</a>\n<a href=\"#L-4\"> 4</a>\n<a href=\"#L-5\"> 5</a>\n<a href=\"#L-6\"> 6</a>\n<a href=\"#L-7\"> 7</a>\n<a href=\"#L-8\"> 8</a>\n<a href=\"#L-9\"> 9</a>\n<a href=\"#L-10\">10</a>\n<a href=\"#L-11\">11</a>\n<a href=\"#L-12\">12</a>\n<a href=\"#L-13\">13</a>\n<a href=\"#L-14\">14</a>\n<a href=\"#L-15\">15</a>\n<a href=\"#L-16\">16</a>\n<a href=\"#L-17\">17</a>\n<a href=\"#L-18\">18</a>\n<a href=\"#L-19\">19</a>\n<a href=\"#L-20\">20</a>\n<a href=\"#L-21\">21</a>\n<a href=\"#L-22\">22</a>\n<a href=\"#L-23\">23</a>\n<a href=\"#L-24\">24</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 * from addresses&quot;;\n</span><span id=\"L-2\"><a name=\"L-2\"></a>      new Promise(function (resolve, reject) {\n</span><span id=\"L-3\"><a name=\"L-3\"></a>        JwApp.db.executeSql(sql, [], function (resultSet) {\n</span><span id=\"L-4\"><a name=\"L-4\"></a>          console.log(&#39;Length: &#39;+resultSet.rows.length);\n</span><span id=\"L-5\"><a name=\"L-5\"></a>\n</span><span id=\"L-6\"><a name=\"L-6\"></a>          for(var i = 0; i &lt; resultSet.rows.length; i++) {\n</span><span id=\"L-7\"><a name=\"L-7\"></a>            results[resultSet.rows.item(i).id] = resultSet.rows.item(i);\n</span><span id=\"L-8\"><a name=\"L-8\"></a>          }\n</span><span id=\"L-9\"><a name=\"L-9\"></a>\n</span><span id=\"L-10\"><a name=\"L-10\"></a>          console.log(results);\n</span><span id=\"L-11\"><a name=\"L-11\"></a>          resolve(results);\n</span><span id=\"L-12\"><a name=\"L-12\"></a>        }, function(error) {\n</span><span id=\"L-13\"><a name=\"L-13\"></a>          console.log(&#39;SELECT error: &#39; + error.message);\n</span><span id=\"L-14\"><a name=\"L-14\"></a>          reject(error.message);\n</span><span id=\"L-15\"><a name=\"L-15\"></a>        })\n</span><span id=\"L-16\"><a name=\"L-16\"></a>      })\n</span><span id=\"L-17\"><a name=\"L-17\"></a>      .then(function (res) {\n</span><span id=\"L-18\"><a name=\"L-18\"></a>        console.log(&#39;Execuited Then&#39;);\n</span><span id=\"L-19\"><a name=\"L-19\"></a>        console.log(res);\n</span><span id=\"L-20\"><a name=\"L-20\"></a>      })\n</span><span id=\"L-21\"><a name=\"L-21\"></a>      .catch(function (res) {\n</span><span id=\"L-22\"><a name=\"L-22\"></a>        console.log(&#39;Execuited Then Reject&#39;);\n</span><span id=\"L-23\"><a name=\"L-23\"></a>        console.log(&#39;SQL error: &#39;+res);\n</span><span id=\"L-24\"><a name=\"L-24\"></a>      });\n</span></pre></div>\n</td></tr></table>", "tags": [{"absolute_url": "/public/tag/javascript/", "id": 5, "name": "javascript", "resource_uri": "/api/public/tag/5/", "snipts": "/api/public/snipt/?tag=5"}, {"absolute_url": "/public/tag/ionic/", "id": 15, "name": "ionic", "resource_uri": "/api/public/tag/15/", "snipts": "/api/public/snipt/?tag=15"}, {"absolute_url": "/public/tag/angular/", "id": 16, "name": "angular", "resource_uri": "/api/public/tag/16/", "snipts": "/api/public/snipt/?tag=16"}], "title": "JavaScript Promise", "user": {"absolute_url": "/jbmckee/", "email_md5": "f4da96308b6db1b0b19738a7c105d3da", "id": 1, "resource_uri": "/api/public/user/1/", "snipts": "/api/public/snipt/?user=1", "snipts_count": 72, "username": "jbmckee"}}