[Phpgroupware-cvs] property/inc/class.soactor.inc.php, 1.4.2.7

[nomail]

Update of /property/inc
Modified Files:
        Branch: proposed-0_9_18-branch
          class.soactor.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.soactor.inc.php
diff -u property/inc/class.soactor.inc.php:1.4.2.6 
property/inc/class.soactor.inc.php:1.4.2.7
--- property/inc/class.soactor.inc.php:1.4.2.6  Fri Nov 26 11:23:38 2004
+++ property/inc/class.soactor.inc.php  Tue Dec  7 09:04:28 2004
@@ -39,6 +39,7 @@
 
                        $this->join                     = $this->bocommon->join;
                        $this->left_join        = $this->bocommon->left_join;
+                       $this->like                     = $this->bocommon->like;
                }
 
                function select_category_list()
@@ -211,7 +212,7 @@
 
                        if ($member_id>0)
                        {
-                               $filtermethod .= " $where 
$entity_table.member_of LIKE '%,$member_id,%' ";
+                               $filtermethod .= " $where 
$entity_table.member_of $this->like '%,$member_id,%' ";
                                $where= 'AND';
                        }
 
@@ -236,7 +237,7 @@
                                {
                                        if($this->db->f('datatype')=='V' || 
$this->db->f('datatype')=='email' || $this->db->f('datatype')=='CH')
                                        {
-                                               $querymethod[]= 
"$entity_table." . $this->db->f('column_name') . " LIKE '%$query%'";
+                                               $querymethod[]= 
"$entity_table." . $this->db->f('column_name') . " $this->like '%$query%'";
                                        }
                                        else
                                        {
@@ -529,7 +530,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " $where 
($attribute_table.input_text LIKE '%$query%' or $attribute_table.column_name 
LIKE '%$query%')";
+                               $querymethod = " $where 
($attribute_table.input_text $this->like '%$query%' or 
$attribute_table.column_name $this->like '%$query%')";
                        }
 
                        $sql = "SELECT * FROM $attribute_table $filtermethod 
$querymethod";