From f2eeb9006f36d49a222e55f4d595a79cdef496fb Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 9 Nov 2004 09:31:09 +0000
Subject: [PATCH] parenthesis help alot

---
 httemplate/search/report_tax.cgi | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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",
-- 
2.11.0