diff options
author | Andrew Dolgov <[email protected]> | 2009-02-04 14:20:25 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-02-04 14:20:25 +0300 |
commit | 03c96380edf86bc2b4dd44000310c559afeb6d1f (patch) | |
tree | f2d9bf82adc1434381e8ed4c00495919e8095a7d /viewfeed.js | |
parent | 3034277ab5895723f10addad06d157d54bf188fa (diff) |
offline: properly close resultsets with rs.close()
Diffstat (limited to 'viewfeed.js')
-rw-r--r-- | viewfeed.js | 28 |
1 files changed, 24 insertions, 4 deletions
diff --git a/viewfeed.js b/viewfeed.js index 7aaa7f77b..d4967aefa 100644 --- a/viewfeed.js +++ b/viewfeed.js @@ -1520,11 +1520,16 @@ function cache_find(id) { if (db) { var rs = db.execute("SELECT article FROM cache WHERE id = ?", [id]); + var a = false; if (rs.isValidRow()) { - return rs.field(0); + var a = rs.field(0); } + rs.close(); + + return a; + } else { for (var i = 0; i < article_cache.length; i++) { if (article_cache[i]["id"] == id) { @@ -1540,11 +1545,16 @@ function cache_find_param(id, param) { if (db) { var rs = db.execute("SELECT article FROM cache WHERE id = ? AND param = ?", [id, param]); + var a = false; if (rs.isValidRow()) { - return rs.field(0); + a = rs.field(0); } + rs.close(); + + return a; + } else { for (var i = 0; i < article_cache.length; i++) { if (article_cache[i]["id"] == id && article_cache[i]["param"] == param) { @@ -1560,11 +1570,16 @@ function cache_check(id) { if (db) { var rs = db.execute("SELECT COUNT(*) AS c FROM cache WHERE id = ?", [id]); + var a = false; if (rs.isValidRow()) { - return rs.field(0) != "0"; + a = rs.field(0) != "0"; } + rs.close(); + + return a; + } else { for (var i = 0; i < article_cache.length; i++) { if (article_cache[i]["id"] == id) { @@ -1580,11 +1595,16 @@ function cache_check_param(id, param) { if (db) { var rs = db.execute("SELECT COUNT(*) AS c FROM cache WHERE id = ? AND param = ?", [id, param]); + var a = false; if (rs.isValidRow()) { - return rs.field(0) != "0"; + a = rs.field(0) != "0"; } + rs.close(); + + return a; + } else { for (var i = 0; i < article_cache.length; i++) { if (article_cache[i]["id"] == id && article_cache[i]["param"] == param) { |