From: ivan Date: Tue, 18 Sep 2007 21:41:13 +0000 (+0000) Subject: and parens help alot, doh X-Git-Tag: TRIXBOX_2_6~364 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=1bcfff5d94b4b3adbbdb964fcdc76ff7ad64ba04 and parens help alot, doh --- diff --git a/httemplate/search/svc_broadband.cgi b/httemplate/search/svc_broadband.cgi index c61bc8a72..fb1ecf4e1 100755 --- a/httemplate/search/svc_broadband.cgi +++ b/httemplate/search/svc_broadband.cgi @@ -37,12 +37,13 @@ % %} elsif ( $cgi->param('svcpart') =~ /^(\d+)$/ ) { % -% @svc_broadband = qsearch( { -% 'table' => 'svc_broadband', -% 'addl_from' => 'LEFT JOIN cust_svc USING svcnum', -% 'extra_sql' => "WHERE svcpart = $1", -% } -% ); +% @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;