From 8fd8fc66ed88d20b34bcbd267a77f70eaa354f48 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 21 Nov 2003 15:25:51 +0000 Subject: [PATCH] precedence helps alot --- httemplate/search/report_receivables.cgi | 6 +++--- 1 file 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 -- 2.11.0