[Phpgroupware-cvs] property/inc/class.socommon.inc.php, 1.5.2.4

[nomail]

Update of /property/inc
Modified Files:
        Branch: proposed-0_9_18-branch
          class.socommon.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.socommon.inc.php
diff -u property/inc/class.socommon.inc.php:1.5.2.3 
property/inc/class.socommon.inc.php:1.5.2.4
--- property/inc/class.socommon.inc.php:1.5.2.3 Thu Nov 18 22:12:08 2004
+++ property/inc/class.socommon.inc.php Tue Dec  7 09:04:28 2004
@@ -39,11 +39,12 @@
                        if 
($GLOBALS['phpgw_info']['server']['db_type']=='pgsql')
                        {
                                $this->join = " JOIN ";
+                               $this->like = "ILIKE";
                        }
                        else
                        {
                                $this->join = " INNER JOIN ";
-//                             $this->join = " LEFT JOIN ";
+                               $this->like = "LIKE";
                        }
 
                        $this->left_join = " LEFT JOIN ";
@@ -87,7 +88,7 @@
                                $security .= "," . $group['account_id'];
                        }
 
-                       $sql = "SELECT * FROM phpgw_accounts $this->join 
fm_acl2 on phpgw_accounts.account_id=fm_acl2.acl_account where acl_location 
LIKE '%$acl_location%' order by account_lastname ASC";
+                       $sql = "SELECT * FROM phpgw_accounts $this->join 
fm_acl2 on phpgw_accounts.account_id=fm_acl2.acl_account where acl_location 
$this->like '%$acl_location%' order by account_lastname ASC";
                        $this->db->query($sql,__LINE__,__FILE__);
                        while ($this->db->next_record())
                        {