[Phpgroupware-cvs] property/inc/class.soalarm.inc.php, 1.2.2.5

[nomail]

Update of /property/inc
Modified Files:
        Branch: proposed-0_9_18-branch
          class.soalarm.inc.php

date: 2004/12/07 09:04:28;  author: sigurdne;  state: Exp;  lines: +5 -4

Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.soalarm.inc.php
diff -u property/inc/class.soalarm.inc.php:1.2.2.4 
property/inc/class.soalarm.inc.php:1.2.2.5
--- property/inc/class.soalarm.inc.php:1.2.2.4  Thu Nov 18 22:12:08 2004
+++ property/inc/class.soalarm.inc.php  Tue Dec  7 09:04:28 2004
@@ -37,6 +37,7 @@
                        $this->socommon         = 
CreateObject($this->currentapp.'.socommon');
 
                        $this->join                     = $this->socommon->join;
+                       $this->like                     = $this->socommon->like;
                }
 
                function select_method_list()
@@ -108,13 +109,13 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " $where ( abid = '$query' or 
org_name LIKE '%$query%')";
+                               $querymethod = " $where ( abid = '$query' or 
org_name $this->like '%$query%')";
                        }
 */
                        $id = $this->db->db_addslashes($id);
                        if (strpos($id,'%') !== False || strpos($id,'_') !== 
False)
                        {
-                               $filtermethod = "$where id LIKE '%$id%' AND 
id!='##last-check-run##'";
+                               $filtermethod = "$where id $this->like '%$id%' 
AND id!='##last-check-run##'";
                        }
                        elseif (!$id)
                        {
@@ -167,7 +168,7 @@
                        $id = $this->db->db_addslashes($id);
                        if (strpos($id,'%') !== False || strpos($id,'_') !== 
False)
                        {
-                               $where = "id LIKE '%$id%' AND 
id!='##last-check-run##'";
+                               $where = "id $this->like '%$id%' AND 
id!='##last-check-run##'";
                        }
                        elseif (!$id)
                        {