[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc/class.sos_agreement.inc.php, 1.10.2.9
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/inc/class.sos_agreement.inc.php, 1.10.2.9 |
Date: |
Tue, 7 Dec 2004 10:04:28 +0100 |
Update of /property/inc
Modified Files:
Branch: proposed-0_9_18-branch
class.sos_agreement.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.sos_agreement.inc.php
diff -u property/inc/class.sos_agreement.inc.php:1.10.2.8
property/inc/class.sos_agreement.inc.php:1.10.2.9
--- property/inc/class.sos_agreement.inc.php:1.10.2.8 Thu Nov 18 22:12:08 2004
+++ property/inc/class.sos_agreement.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;
// $this->role = 's_agreement';
}
@@ -327,7 +328,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';
}
@@ -349,7 +350,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
{
@@ -1021,7 +1022,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";
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/inc/class.sos_agreement.inc.php, 1.10.2.9,
nomail <=