SF.net SVN: ledger-smb: [1262] branches/1.2/LedgerSMB/CT.pm

[..hidden..]

Revision: 1262
          http://svn.sourceforge.net/ledger-smb/?rev=1262&view=rev
Author:   einhverfr
Date:     2007-06-10 21:40:57 -0700 (Sun, 10 Jun 2007)

Log Message:
-----------
Fixing error searching by address

Modified Paths:
--------------
    branches/1.2/LedgerSMB/CT.pm

Modified: branches/1.2/LedgerSMB/CT.pm
===================================================================
--- branches/1.2/LedgerSMB/CT.pm	2007-06-10 15:56:40 UTC (rev 1261)
+++ branches/1.2/LedgerSMB/CT.pm	2007-06-11 04:40:57 UTC (rev 1262)
@@ -608,7 +608,7 @@
     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} ) {


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.