diff options
| author | ivan <ivan> | 2004-11-09 09:31:09 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-11-09 09:31:09 +0000 |
| commit | f2eeb9006f36d49a222e55f4d595a79cdef496fb (patch) | |
| tree | 53731d82873bdb520ac6fb49ab8730dac774fe13 | |
| parent | 5b385021976c25fd312da16e9430df1fe4e89457 (diff) | |
parenthesis help alot
| -rwxr-xr-x | httemplate/search/report_tax.cgi | 2 |
1 files changed, 1 insertions, 1 deletions
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", |