[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc/class.soadmin_location.inc.php, 1.2.2.4
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/inc/class.soadmin_location.inc.php, 1.2.2.4 |
Date: |
Tue, 7 Dec 2004 10:04:28 +0100 |
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,"
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/inc/class.soadmin_location.inc.php, 1.2.2.4,
nomail <=