diff options
| author | ivan <ivan> | 2003-11-21 15:25:51 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-11-21 15:25:51 +0000 |
| commit | 8fd8fc66ed88d20b34bcbd267a77f70eaa354f48 (patch) | |
| tree | eb31cae74dd0a05f5138a82e9b82e18e60843a44 /httemplate/search | |
| parent | 8ded47043e6d1f002a57c392fa95f481e697ab45 (diff) | |
precedence helps alot
Diffstat (limited to 'httemplate/search')
| -rwxr-xr-x | httemplate/search/report_receivables.cgi | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index 108453d43..f42269f65 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -70,14 +70,14 @@ END ( select count(*) from cust_pkg where cust_main.custnum = cust_pkg.custnum and $recurring - and cancel = 0 or cancel is null + and ( cancel = 0 or cancel is null ) ) as uncancelled_pkgs, ( select count(*) from cust_pkg where cust_main.custnum = cust_pkg.custnum and $recurring - and cancel = 0 or cancel is null - and susp = 0 or susp is null + and ( cancel = 0 or cancel is null ) + and ( susp = 0 or susp is null ) ) as active_pkgs END |