diff options
author | ivan <ivan> | 2007-09-18 21:37:34 +0000 |
---|---|---|
committer | ivan <ivan> | 2007-09-18 21:37:34 +0000 |
commit | 73c14ce2664742e2a063dc49f941e87b78209467 (patch) | |
tree | 256589856ad8cbd8cca2c25e6fce9b0ab395b0dd /httemplate | |
parent | 32635b5ca3bbc3b75ace232c86945ea5b83066e2 (diff) |
fix svc_broadband search by svcpart (links from browse/part_svc, in particular
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> |