-if ( scalar(@svc_forward) == 1 ) {
- print $cgi->redirect(popurl(2). "view/svc_forward.cgi?". $svc_forward[0]->svcnum);
- #exit;
-} elsif ( scalar(@svc_forward) == 0 ) {
-%>
-<!-- mason kludge -->
-<%
- eidiot "No matching forwards found!\n";
-} else {
-%>
-<!-- mason kludge -->
-<%
- my $total = scalar(@svc_forward);
- print header("Mail forward Search Results",''), <<END;
+my $count_query = 'SELECT COUNT(*) FROM svc_forward';
+my $sql_query = {
+ 'table' => 'svc_forward',
+ 'hashref' => {},
+ 'select' => join(', ',
+ 'svc_forward.*',
+ map "cust_main.$_", qw(custnum last first company)
+ ),
+ 'extra_sql' => $orderby,
+ 'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum )'.
+ 'LEFT JOIN cust_pkg USING ( pkgnum )'.
+ 'LEFT JOIN cust_main USING ( custnum )',
+};