From d8d41658d3fb87c71c3e30825003f827f4ffbdae Mon Sep 17 00:00:00 2001 From: alecpl Date: Sat, 9 Aug 2008 20:20:59 +0000 Subject: - Case insensitive contacts searching using PostgreSQL (#1485259) --- program/include/rcube_contacts.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'program/include/rcube_contacts.php') diff --git a/program/include/rcube_contacts.php b/program/include/rcube_contacts.php index 913f04fd3..0c0f932fc 100644 --- a/program/include/rcube_contacts.php +++ b/program/include/rcube_contacts.php @@ -196,12 +196,12 @@ class rcube_contacts if ($col == 'ID' || $col == $this->primary_key) { $ids = !is_array($value) ? split(',', $value) : $value; - $add_where[] = $this->primary_key." IN (".join(',', $ids).")"; + $add_where[] = $this->primary_key.' IN ('.join(',', $ids).')'; } else if ($strict) - $add_where[] = $this->db->quoteIdentifier($col)."=".$this->db->quote($value); + $add_where[] = $this->db->quoteIdentifier($col).'='.$this->db->quote($value); else - $add_where[] = $this->db->quoteIdentifier($col)." LIKE ".$this->db->quote(strlen($value)>2 ? "%$value%" : "$value%"); + $add_where[] = $this->db->ilike($col, '%'.$value.'%'); } if (!empty($add_where)) -- cgit v1.2.3