From 916298e0a26fad5489abc5efd1a98d8ee69f65e0 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Mon, 11 Jun 2007 04:40:57 +0000 Subject: Fixing error searching by address git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1262 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/CT.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/LedgerSMB/CT.pm b/LedgerSMB/CT.pm index 1477b9fc..e40b3336 100755 --- a/LedgerSMB/CT.pm +++ b/LedgerSMB/CT.pm @@ -608,7 +608,7 @@ sub search { if ( $form->{address} ne "" ) { $var = $dbh->quote( $form->like( lc $form->{address} ) ); $where .= -" AND (lower(ct.address1) LIKE $var OR lower(ct.address2) LIKE '$var')"; +" AND (lower(ct.address1) ILIKE $var)"; } if ( $form->{startdatefrom} ) { -- cgit v1.2.3