phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: nomail
Subject: [Phpgroupware-cvs] property/inc/class.soentity.inc.php, 1.2.2.5
Date: Tue, 7 Dec 2004 10:04:28 +0100

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

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

Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.soentity.inc.php
diff -u property/inc/class.soentity.inc.php:1.2.2.4 
property/inc/class.soentity.inc.php:1.2.2.5
--- property/inc/class.soentity.inc.php:1.2.2.4 Thu Nov 18 22:12:08 2004
+++ property/inc/class.soentity.inc.php Tue Dec  7 09:04:28 2004
@@ -37,6 +37,7 @@
 
                        $this->join                     = $this->bocommon->join;
                        $this->left_join        = $this->bocommon->left_join;
+                       $this->like                     = $this->bocommon->like;
                }
 
                function select_status_list($entity_id,$cat_id)
@@ -258,7 +259,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " $where ( 
$entity_table.location_code LIKE '%$query%' OR $entity_table.num LIKE 
'%$query%'  OR loc1_name LIKE '%$query%' OR address LIKE '%$query%')";
+                               $querymethod = " $where ( 
$entity_table.location_code $this->like '%$query%' OR $entity_table.num 
$this->like '%$query%'  OR loc1_name $this->like '%$query%' OR address 
$this->like '%$query%')";
                                $where = 'AND';
                        }
 




reply via email to

[Prev in Thread] Current Thread [Next in Thread]