diff options
| author | ivan <ivan> | 2004-11-09 09:31:10 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-11-09 09:31:10 +0000 |
| commit | ba50ec34aa882a14256550052a2b061d5c6fcb81 (patch) | |
| tree | ec38d570832c19ddd4b4ad56d7d6a36cbf312870 | |
| parent | a744e0eb79729b05563679fdf8ede6468621bc0f (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", |