diff options
| author | jocuri%softhome.net <> | 2004-07-31 18:36:18 +0200 |
|---|---|---|
| committer | jocuri%softhome.net <> | 2004-07-31 18:36:18 +0200 |
| commit | b37e43b5ab5a2dda0d50aa1e32b816a799f79bf6 (patch) | |
| tree | c324f0cdca9d3f482bcf4dec1dafb10d76f14e3b /editgroups.cgi | |
| parent | 7cea397f3ea0988b4edd4b2225fc65bf28b63611 (diff) | |
| download | bugzilla-b37e43b5ab5a2dda0d50aa1e32b816a799f79bf6.tar.gz bugzilla-b37e43b5ab5a2dda0d50aa1e32b816a799f79bf6.tar.xz | |
Patch for bug 253360: replace IF() with CASE WHEN for database compatibility; patch by Tomas Kopal <Tomas.Kopal@altap.cz>; r=vladd, a=justdave.
Diffstat (limited to 'editgroups.cgi')
| -rwxr-xr-x | editgroups.cgi | 6 |
1 files changed, 3 insertions, 3 deletions
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" . |