diff options
Diffstat (limited to 'httemplate')
| -rwxr-xr-x | httemplate/search/svc_broadband.cgi | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/httemplate/search/svc_broadband.cgi b/httemplate/search/svc_broadband.cgi index a89b19610..c61bc8a72 100755 --- a/httemplate/search/svc_broadband.cgi +++ b/httemplate/search/svc_broadband.cgi @@ -37,11 +37,12 @@ % %} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) { % -% @svc_broadband = -% qsearch( 'svc_broadband', {}, '', -% " WHERE $1 = ( SELECT svcpart FROM cust_svc ". -% " WHERE cust_svc.svcnum = svc_external.svcnum ) " -% ); +% @svc_broadband = qsearch( { +% 'table' => 'svc_broadband', +% 'addl_from' => 'LEFT JOIN cust_svc USING svcnum', +% 'extra_sql' => "WHERE svcpart = $1", +% } +% ); % %} elsif ( $cgi->param('ip_addr') =~ /^(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})$/ ) { % my $ip_addr = $1; @@ -63,14 +64,14 @@ <!-- mason kludge --> % -% eidiot "No matching ip address found!\n"; +% eidiot "No matching broadband services found!\n"; %} else { % <!-- mason kludge --> % % my($total)=scalar(@svc_broadband); -% print header("IP Address Search Results",''), <<END; +% print header("Broadband Search Results",''), <<END; % % $total matching broadband services found % <TABLE BORDER=4 CELLSPACING=0 CELLPADDING=0> |