From 475ae93877f1d834941f7b9adcc35ee84c5c22fa Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Mon, 2 Feb 2015 22:10:44 -0800 Subject: [PATCH] fix prospect contact search --- httemplate/search/contact.html | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/httemplate/search/contact.html b/httemplate/search/contact.html index 193349369..650307824 100644 --- a/httemplate/search/contact.html +++ b/httemplate/search/contact.html @@ -34,18 +34,19 @@ if ( $cgi->param('selfservice_access') eq 'Y' ) { my $extra_sql = ''; if ( $cgi->param('link') ) { - my $coalesce = ', COALESCE( cust_main.company,'; my $as = ') AS prospect_or_customer'; if ( $cgi->param('link') eq 'cust_main' ) { push @header, 'Customer'; - $select .= "$coalesce cust_main.first||' '||cust_main.last $as"; + $select .= + ", COALESCE( cust_main.company, cust_main.first||' '||cust_main.last $as"; $addl_from = ' LEFT JOIN cust_main USING ( custnum )'; $extra_sql = ' custnum IS NOT NULL '; $company_link = [ $p.'view/cust_main.cgi?', 'custnum' ]; } elsif ( $cgi->param('link') eq 'prospect_main' ) { push @header, 'Prospect'; - $select .= "$coalesce contact.first||' '||contact.last $as"; + $select .= + ", COALESCE( prospect_main.company, contact.first||' '||contact.last $as"; $addl_from = ' LEFT JOIN prospect_main USING ( prospectnum )'; $extra_sql = ' prospectnum IS NOT NULL '; $company_link = [ $p.'view/prospect_main.html?', 'prospectnum' ]; -- 2.11.0