diff options
| author | ivan <ivan> | 2004-05-28 10:17:08 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-05-28 10:17:08 +0000 |
| commit | 0d81e56d3651752576b4969b39b49dc80012fc0e (patch) | |
| tree | ddcfd256941dbf43e8de09e8683e146c6736d4b8 /httemplate | |
| parent | 59eec66f424ee1a5e25b2d5853dbe505581b9a07 (diff) | |
correct count statement when searching for individual invoices by #
Diffstat (limited to 'httemplate')
| -rwxr-xr-x | httemplate/search/cust_bill.html | 2 |
1 files changed, 1 insertions, 1 deletions
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 }, |