[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc/class.soworkorder.inc.php, 1.3.2.4
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/inc/class.soworkorder.inc.php, 1.3.2.4 |
Date: |
Tue, 7 Dec 2004 10:04:28 +0100 |
Update of /property/inc
Modified Files:
Branch: proposed-0_9_18-branch
class.soworkorder.inc.php
date: 2004/12/07 09:04:28; author: sigurdne; state: Exp; lines: +4 -3
Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.soworkorder.inc.php
diff -u property/inc/class.soworkorder.inc.php:1.3.2.3
property/inc/class.soworkorder.inc.php:1.3.2.4
--- property/inc/class.soworkorder.inc.php:1.3.2.3 Thu Nov 18 22:12:08 2004
+++ property/inc/class.soworkorder.inc.php Tue Dec 7 09:04:28 2004
@@ -38,6 +38,7 @@
$this->join = $this->bocommon->join;
$this->left_join = $this->bocommon->left_join;
+ $this->like = $this->bocommon->like;
$this->grants =
$GLOBALS['phpgw']->session->appsession('grants_project',$this->currentapp);
if(!$this->grants)
@@ -313,7 +314,7 @@
$query = ereg_replace("'",'',$query);
$query = ereg_replace('"','',$query);
- $querymethod = " $where
(fm_workorder.title LIKE '%$query%' or fm_workorder.descr LIKE '%$query%' or
fm_project.address LIKE '%$query%' or fm_project.location_code LIKE '%$query%'
or fm_workorder.id LIKE '%$query%')";
+ $querymethod = " $where
(fm_workorder.title $this->like '%$query%' or fm_workorder.descr $this->like
'%$query%' or fm_project.address $this->like '%$query%' or
fm_project.location_code $this->like '%$query%' or fm_workorder.id $this->like
'%$query%')";
}
$where= 'AND';
@@ -327,7 +328,7 @@
}
else
{
- $querymethod_vendor = " $where
fm_vendor.org_name LIKE '%$search_vendor%'";
+ $querymethod_vendor = " $where
fm_vendor.org_name $this->like '%$search_vendor%'";
}
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/inc/class.soworkorder.inc.php, 1.3.2.4,
nomail <=