diff options
author | ivan <ivan> | 2011-06-02 21:52:57 +0000 |
---|---|---|
committer | ivan <ivan> | 2011-06-02 21:52:57 +0000 |
commit | 3907da4465b5ca211f9af7556f811eff252fcd23 (patch) | |
tree | 66d26fe92d93c664a1721de37047a1e02e663b1f /httemplate/search | |
parent | d632cda4e4c3e77d63ce61aae4096e4c81c29b9d (diff) |
fix svc_port searches
Diffstat (limited to 'httemplate/search')
-rw-r--r-- | httemplate/search/cust_svc.html | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html index 72ecb8e..9cf4bbd 100644 --- a/httemplate/search/cust_svc.html +++ b/httemplate/search/cust_svc.html @@ -75,6 +75,7 @@ if ( length( $cgi->param('search_svc') ) ) { $cgi->param('svcdb') =~ /^(svc_\w+)$/ or die "unknown svcdb"; push @extra_sql, "svcdb = '$1'"; + $addl_from .= " LEFT JOIN $1 USING ( svcnum ) "; push @extra_sql, 'pkgnum IS NULL' if $cgi->param('magic') eq 'unlinked'; |