SF.net SVN: ledger-smb:[2629] trunk/LedgerSMB/Form.pm

[..hidden..]

Revision: 2629
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2629&view=rev
Author:   einhverfr
Date:     2009-06-08 00:12:39 +0000 (Mon, 08 Jun 2009)

Log Message:
-----------
Fixing a bug where upper-case letters prevent contracts from showing up on ar/ap transaction screens

Modified Paths:
--------------
    trunk/LedgerSMB/Form.pm

Modified: trunk/LedgerSMB/Form.pm
===================================================================
--- trunk/LedgerSMB/Form.pm	2009-06-05 22:48:35 UTC (rev 2628)
+++ trunk/LedgerSMB/Form.pm	2009-06-08 00:12:39 UTC (rev 2629)
@@ -1704,13 +1704,12 @@
 		SELECT c.*, e.name, e.control_code FROM entity_credit_account c
 		JOIN entity e ON (c.entity_id = e.id)
 		WHERE (lower(e.name) LIKE ?
-		OR c.meta_number LIKE ?)
+		OR c.meta_number ILIKE ?)
 		$where
 		ORDER BY e.name/;
 
     unshift( @queryargs, $name, $self->{"${table}number"} );
     my $sth = $self->{dbh}->prepare($query);
-
     $sth->execute(@queryargs) || $self->dberror($query);
 
     my $i = 0;


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