changeset 82:2c1612f4cb28

Fix SQL syntax error when read = 1
author Myk Melez <myk@mozilla.org>
date Thu, 15 May 2008 18:46:06 -0700
parents be9d1c3ae959
children 7ee1176fa699
files extension/modules/collection.js
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/extension/modules/collection.js	Thu May 15 18:01:24 2008 -0700
+++ b/extension/modules/collection.js	Thu May 15 18:46:06 2008 -0700
@@ -163,7 +163,7 @@
       conditions.push("current = " + (this._current ? "1" : "0"));
 
     if (typeof this.read != "undefined")
-      conditions.push("(read = " + (this.read ? "1" : "0 OR read IS NULL)"));
+      conditions.push("(read = " + (this.read ? "1" : "0 OR read IS NULL") + ")");
 
     if (conditions.length > 0)
       query += " WHERE " + conditions.join(" AND ");