projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(from parent 1:
59eec66
)
correct count statement when searching for individual invoices by #
author
ivan
<ivan>
Fri, 28 May 2004 10:17:08 +0000
(10:17 +0000)
committer
ivan
<ivan>
Fri, 28 May 2004 10:17:08 +0000
(10:17 +0000)
httemplate/search/cust_bill.html
patch
|
blob
|
history
diff --git
a/httemplate/search/cust_bill.html
b/httemplate/search/cust_bill.html
index
337e9e8
..
3ae624a
100755
(executable)
--- 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 },