From a5d36cfea18a4cdb756a9270587c15946a6fd1e5 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 14 Feb 2007 01:43:19 +0000 Subject: [PATCH] fix up svc_www searching --- httemplate/search/svc_www.cgi | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/httemplate/search/svc_www.cgi b/httemplate/search/svc_www.cgi index d3b0549c4..d9332e95d 100755 --- a/httemplate/search/svc_www.cgi +++ b/httemplate/search/svc_www.cgi @@ -84,7 +84,7 @@ my $extra_sql = : ''; -my $count_query = 'SELECT COUNT(*) FROM svc_www'; +my $count_query = "SELECT COUNT(*) FROM svc_www $addl_from $extra_sql"; my $sql_query = { 'table' => 'svc_www', 'hashref' => {}, @@ -94,7 +94,7 @@ my $sql_query = { 'cust_main.custnum', FS::UI::Web::cust_sql_fields(), ), - 'extra_sql' => $orderby, + 'extra_sql' => "$extra_sql $orderby", 'addl_from' => $addl_from, }; -- 2.11.0