[Phpgroupware-cvs] property/inc/class.sotts.inc.php, 1.2.2.4

[nomail]

Update of /property/inc
Modified Files:
        Branch: proposed-0_9_18-branch
          class.sotts.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.sotts.inc.php
diff -u property/inc/class.sotts.inc.php:1.2.2.3 
property/inc/class.sotts.inc.php:1.2.2.4
--- property/inc/class.sotts.inc.php:1.2.2.3    Thu Nov 18 22:12:08 2004
+++ property/inc/class.sotts.inc.php    Tue Dec  7 09:04:28 2004
@@ -38,6 +38,7 @@
                        $this->config           = 
CreateObject('phpgwapi.config');
                        $this->bocommon         = 
CreateObject($this->currentapp.'.bocommon');
                        $this->join                     = $this->bocommon->join;
+                       $this->like                     = $this->bocommon->like;
                        $this->soadmin_entity   = 
CreateObject($this->currentapp.'.soadmin_entity');
                        $this->dateformat = 
$GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
 
@@ -168,7 +169,7 @@
                                {
                                        $query = ereg_replace("'",'',$query);
                                        $query = ereg_replace('"','',$query);
-                                       $querymethod = " $where (subject LIKE 
'%$query%' or address LIKE '%$query%' or fm_tts_tickets.location_code LIKE 
'%$query%')";
+                                       $querymethod = " $where (subject 
$this->like '%$query%' or address $this->like '%$query%' or 
fm_tts_tickets.location_code $this->like '%$query%')";
                                }
                        }