From: ivan <ivan>
Date: Tue, 9 Nov 2004 09:31:10 +0000 (+0000)
Subject: parenthesis help alot
X-Git-Tag: freeside_1_4_2~21
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=ba50ec34aa882a14256550052a2b061d5c6fcb81

parenthesis help alot
---

diff --git a/httemplate/search/report_tax.cgi b/httemplate/search/report_tax.cgi
index 601763bba..8cf6bd758 100755
--- a/httemplate/search/report_tax.cgi
+++ b/httemplate/search/report_tax.cgi
@@ -125,7 +125,7 @@ foreach my $r (
   my $named_tax =
     $r->taxname
       ? 'AND itemdesc = '. dbh->quote($r->taxname)
-      : "AND itemdesc IS NULL OR itemdesc = '' OR itemdesc = 'Tax'";
+      : "AND ( itemdesc IS NULL OR itemdesc = '' OR itemdesc = 'Tax' )";
   my $x = scalar_sql($r, \@taxparam,
     "SELECT SUM(cust_bill_pkg.setup+cust_bill_pkg.recur) $taxwhere ".
     "AND pkgnum = 0 $named_tax",