X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_bill.html;h=3ae624af2cf350ede950fbff64ac6afd958ca720;hp=337e9e859343b2d88d7a4cf1dcfb246fe1663919;hb=0d81e56d3651752576b4969b39b49dc80012fc0e;hpb=59eec66f424ee1a5e25b2d5853dbe505581b9a07

diff --git a/httemplate/search/cust_bill.html b/httemplate/search/cust_bill.html
index 337e9e859..3ae624af2 100755
--- a/httemplate/search/cust_bill.html
+++ b/httemplate/search/cust_bill.html
@@ -41,7 +41,7 @@
    
    } else {
      $cgi->param('invnum') =~ /^\s*(FS-)?(\d+)\s*$/;
-     $count_query = 'SELECT 1';
+     $count_query = "SELECT COUNT(*) FROM cust_bill WHERE invnum = $2";
      $sql_query = {
        'table'     => 'cust_bill',
        'hashref'   => { 'invnum' => $2 },