From b37e43b5ab5a2dda0d50aa1e32b816a799f79bf6 Mon Sep 17 00:00:00 2001 From: "jocuri%softhome.net" <> Date: Sat, 31 Jul 2004 16:36:18 +0000 Subject: Patch for bug 253360: replace IF() with CASE WHEN for database compatibility; patch by Tomas Kopal ; r=vladd, a=justdave. --- editgroups.cgi | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'editgroups.cgi') diff --git a/editgroups.cgi b/editgroups.cgi index 96503a125..981fec48a 100755 --- a/editgroups.cgi +++ b/editgroups.cgi @@ -137,9 +137,9 @@ if ($action eq 'changeform') { my @groups; SendSQL("SELECT groups.id, groups.name, groups.description," . - " IF(group_group_map.member_id IS NOT NULL, 1, 0)," . - " IF(B.member_id IS NOT NULL, 1, 0)," . - " IF(C.member_id IS NOT NULL, 1, 0)" . + " CASE WHEN group_group_map.member_id IS NOT NULL THEN 1 ELSE 0 END," . + " CASE WHEN B.member_id IS NOT NULL THEN 1 ELSE 0 END," . + " CASE WHEN C.member_id IS NOT NULL THEN 1 ELSE 0 END" . " FROM groups" . " LEFT JOIN group_group_map" . " ON group_group_map.member_id = groups.id" . -- cgit v1.2.3-24-g4f1b