From d9408a1947a99f2d6f60623374776ad30e36cf8b Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 27 Jul 2007 05:23:50 +0000 Subject: Fixing a large number of SQL errors in certain circumstances git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1446 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/AA.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'LedgerSMB/AA.pm') diff --git a/LedgerSMB/AA.pm b/LedgerSMB/AA.pm index 29bf8ce3..b2df1567 100644 --- a/LedgerSMB/AA.pm +++ b/LedgerSMB/AA.pm @@ -887,12 +887,12 @@ sub transactions { $where .= qq| AND (a.id IN (SELECT DISTINCT trans_id FROM acc_trans - WHERE lower(memo) LIKE '$var') + WHERE lower(memo) LIKE $var) OR a.id IN (SELECT DISTINCT trans_id FROM invoice WHERE lower(description) - LIKE '$var'))|; + LIKE $var))|; } if ($form->{invoice_type}) { -- cgit v1.2.3