[vhffs-dev] [1251] replaced UPPER(something) LIKE UPPER(?) to something ILIKE ?

[subversion@xxxxxxxxxxxxx]

Revision: 1251
Author:   gradator
Date:     2008-09-20 23:11:47 +0200 (Sat, 20 Sep 2008)

Log Message:
-----------
replaced  UPPER(something) LIKE UPPER(?)  to  something ILIKE ?

Modified Paths:
--------------
    trunk/vhffs-api/src/Vhffs/Panel/Group.pm
    trunk/vhffs-api/src/Vhffs/Panel/User.pm


Modified: trunk/vhffs-api/src/Vhffs/Panel/Group.pm
===================================================================
--- trunk/vhffs-api/src/Vhffs/Panel/Group.pm	2008-09-08 14:49:29 UTC (rev 1250)
+++ trunk/vhffs-api/src/Vhffs/Panel/Group.pm	2008-09-20 21:11:47 UTC (rev 1251)
@@ -127,7 +127,7 @@
     }
 
     if(defined $description) {
-        $restriction .= ' AND UPPER(description) LIKE UPPER(?)';
+        $restriction .= ' AND description ILIKE ?';
         push @params, '%'.$description.'%';
     }
 

Modified: trunk/vhffs-api/src/Vhffs/Panel/User.pm
===================================================================
--- trunk/vhffs-api/src/Vhffs/Panel/User.pm	2008-09-08 14:49:29 UTC (rev 1250)
+++ trunk/vhffs-api/src/Vhffs/Panel/User.pm	2008-09-20 21:11:47 UTC (rev 1251)
@@ -136,12 +136,12 @@
     }
 
     if(defined $firstname) {
-        $restriction .= ' AND UPPER(firstname) LIKE UPPER(?)';
+        $restriction .= ' AND firstname ILIKE ?';
         push @params, '%'.$firstname.'%';
     }
 
     if(defined $lastname) {
-        $restriction .= ' AND UPPER(lastname) LIKE UPPER(?)';
+        $restriction .= ' AND lastname ILIKE ?';
         push @params, '%'.$lastname.'%';
     }