diff options
Diffstat (limited to 'httemplate/search')
| -rwxr-xr-x | httemplate/search/qual.cgi | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/httemplate/search/qual.cgi b/httemplate/search/qual.cgi index 58e011406..0bb455b3c 100755 --- a/httemplate/search/qual.cgi +++ b/httemplate/search/qual.cgi @@ -73,6 +73,10 @@ my $extra_sql = ''; if ( $cgi->param('custnum') && $cgi->param('custnum') =~ /^(\d+)$/ ) { $extra_sql = " where custnum = $1 or locationnum in " . " (select locationnum from cust_location where custnum = $1)"; +} elsif ( $cgi->param('prospectnum') + && $cgi->param('prospectnum') =~ /^(\d+)$/ ) { + $extra_sql = " where prospectnum = $1 or locationnum in " + . " (select locationnum from cust_location where prospectnum = $1)"; } </%init> |