diff options
| author | ivan <ivan> | 2003-11-21 15:25:52 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-11-21 15:25:52 +0000 |
| commit | 13723f9307d684b419bca86121a848840f582ad2 (patch) | |
| tree | 07774b973dc4090e0f0d0859ae3a5e51b0365f25 | |
| parent | c6e1ade52b95b0820ce48af87241455c0bf08033 (diff) | |
precedence helps alot
| -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 |