From 00cc8677e25a98e81d70757cc02991e63ee3b975 Mon Sep 17 00:00:00 2001
From: "jocuri%softhome.net" <>
Date: Sat, 3 Jul 2004 07:26:28 +0000
Subject: Patch for bug 248001: Conversion of boolean conditions in SQL
 statements for better DB independence; patch by David Lawrence
 <dkl@redhat.com>; r=joel, vladd; a=justdave.

---
 buglist.cgi | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'buglist.cgi')

diff --git a/buglist.cgi b/buglist.cgi
index 98b7ff116..2607628d0 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -246,9 +246,9 @@ sub GetGroupsByUserId {
     SendSQL("
         SELECT DISTINCT  groups.id, name, description, isactive
                    FROM  groups, user_group_map
-                  WHERE  user_id = $userid AND NOT isbless
+                  WHERE  user_id = $userid AND isbless = 0
                     AND  user_group_map.group_id = groups.id
-                    AND  isbuggroup
+                    AND  isbuggroup = 1
                ORDER BY  description ");
 
     my @groups;
-- 
cgit v1.2.3-24-g4f1b