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. --- editusers.cgi | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'editusers.cgi') diff --git a/editusers.cgi b/editusers.cgi index 5b1c88e98..6d6c844ca 100755 --- a/editusers.cgi +++ b/editusers.cgi @@ -135,9 +135,9 @@ sub EmitFormElements ($$$$) if($user ne "") { print "Group Access:"; SendSQL("SELECT groups.id, groups.name, groups.description, " . - "MAX(IF(grant_type = " . GRANT_DIRECT . ", 1, 0))," . - "MAX(IF(grant_type = " . GRANT_DERIVED . ", 1, 0))," . - "MAX(IF(grant_type = " . GRANT_REGEXP . ", 1, 0))" . + "MAX(CASE WHEN grant_type = " . GRANT_DIRECT . " THEN 1 ELSE 0 END)," . + "MAX(CASE WHEN grant_type = " . GRANT_DERIVED . " THEN 1 ELSE 0 END)," . + "MAX(CASE WHEN grant_type = " . GRANT_REGEXP . " THEN 1 ELSE 0 END)" . "FROM groups " . "LEFT JOIN user_group_map " . "ON user_group_map.group_id = groups.id " . -- cgit v1.2.3-24-g4f1b