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

[nomail]

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

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

Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.soadmin_location.inc.php
diff -u property/inc/class.soadmin_location.inc.php:1.2.2.3 
property/inc/class.soadmin_location.inc.php:1.2.2.4
--- property/inc/class.soadmin_location.inc.php:1.2.2.3 Thu Nov 18 14:45:21 2004
+++ property/inc/class.soadmin_location.inc.php Tue Dec  7 09:04:28 2004
@@ -38,7 +38,7 @@
                        $this->bocommon         = 
CreateObject($this->currentapp.'.bocommon');
 
                        $this->join                     = $this->bocommon->join;
-
+                       $this->like                     = $this->bocommon->like;
                }
 
 
@@ -81,7 +81,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " where name LIKE '%$query%' or 
descr LIKE '%$query%'";
+                               $querymethod = " where name $this->like 
'%$query%' or descr $this->like '%$query%'";
                        }
 
                        $sql = "SELECT * FROM $table $querymethod";
@@ -135,7 +135,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " where name LIKE '%$query%' or 
column_name LIKE '%$query%'";
+                               $querymethod = " where name $this->like 
'%$query%' or column_name $this->like '%$query%'";
                        }
 
                        $sql = "SELECT fm_location_config.* 
,fm_location_type.name as name FROM fm_location_config  $this->join 
fm_location_type on fm_location_config.location_type=fm_location_type.id 
$querymethod";
@@ -410,7 +410,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " and ($table.name LIKE 
'%$query%' or $table.descr LIKE '%$query%')";
+                               $querymethod = " and ($table.name $this->like 
'%$query%' or $table.descr $this->like '%$query%')";
                        }
 
                        $sql = "SELECT 
$table.id,$table.type_id,$table.list,$table.attrib_sort,$table.location_form,lookup_form,$table.column_name,$table.size
 ,statustext,$table.input_text,"