From ac6c8883615cd02d768c3222e38b59c3a51b7e7a Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 25 Dec 2005 03:07:32 +0000 Subject: [PATCH] correct "out of taxable region" flag on new line item report - NULLs need to be compared explicitly. apparantly NULL != NULL. bah SQL --- httemplate/search/cust_bill_pkg.cgi | 25 ++++++++++++++----------- 1 file changed, 14 insertions(+), 11 deletions(-) diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi index f84293a9d..082ccc893 100644 --- a/httemplate/search/cust_bill_pkg.cgi +++ b/httemplate/search/cust_bill_pkg.cgi @@ -20,18 +20,21 @@ my $where = " if ( $cgi->param('out') ) { $where .= " - AND 0 = ( SELECT COUNT(*) FROM cust_main_county - WHERE ( cust_main_county.county = cust_main.county - OR cust_main_county.county IS NULL AND cust_main.county = '' - OR cust_main_county.county = '' AND cust_main.county IS NULL - ) - AND ( cust_main_county.state = cust_main.state - OR cust_main_county.state IS NULL AND cust_main.state = '' - OR cust_main_county.state = '' AND cust_main.state IS NULL - ) - AND cust_main_county.country = cust_main.country - AND cust_main_county.tax > 0 + AND 0 = ( + SELECT COUNT(*) FROM cust_main_county + WHERE ( cust_main_county.county = cust_main.county + OR ( cust_main_county.county IS NULL AND cust_main.county = '' ) + OR ( cust_main_county.county = '' AND cust_main.county IS NULL) + OR ( cust_main_county.county IS NULL AND cust_main.county IS NULL) ) + AND ( cust_main_county.state = cust_main.state + OR ( cust_main_county.state IS NULL AND cust_main.state = '' ) + OR ( cust_main_county.state = '' AND cust_main.state IS NULL ) + OR ( cust_main_county.state IS NULL AND cust_main.state IS NULL ) + ) + AND cust_main_county.country = cust_main.country + AND cust_main_county.tax > 0 + ) "; } elsif ( $cgi->param('country' ) ) { -- 2.11.0