[Phpgroupware-cvs] CVS: phpgwapi/inc class.contacts_sql.inc.php,1.20,1.21

[Miles Lott <address@hidden>]

Update of /cvsroot/phpgroupware/phpgwapi/inc
In directory subversions:/tmp/cvs-serv19095

Modified Files:
        class.contacts_sql.inc.php 
Log Message:
case-insensitive check for 1st char (some rdbms)

Index: class.contacts_sql.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -r1.20 -r1.21
*** class.contacts_sql.inc.php  13 May 2002 23:27:40 -0000      1.20
--- class.contacts_sql.inc.php  13 May 2002 23:39:30 -0000      1.21
***************
*** 485,488 ****
--- 485,491 ----
                        if($cquery)
                        {
+                               $cqueryl = strtolower($cquery);
+                               $cqueryu = strtoupper($cquery);
+ 
                                $sql = "SELECT * FROM $this->std_table WHERE (";
                                $cfields = array(
***************
*** 493,500 ****
                                while(list($f,$x) = each($cfields))
                                {
!                                       $sql .= " $f LIKE '$cquery%' OR ";
                                }
                                $sql = substr($sql,0,-3) . ') ' . $fand . 
$filtermethod . $ordermethod;
                                unset($f); unset($x);
                        }
                        elseif($query)
--- 496,504 ----
                                while(list($f,$x) = each($cfields))
                                {
!                                       $sql .= " $f LIKE '$cqueryl%' OR $f 
LIKE '$cqueryu%' OR ";
                                }
                                $sql = substr($sql,0,-3) . ') ' . $fand . 
$filtermethod . $ordermethod;
                                unset($f); unset($x);
+                               unset($cqueryl); unset($cqueryu);
                        }
                        elseif($query)