projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
c89d696
)
don't forget to where the where clause
author
ivan
<ivan>
Sun, 7 Jul 2002 13:25:12 +0000
(13:25 +0000)
committer
ivan
<ivan>
Sun, 7 Jul 2002 13:25:12 +0000
(13:25 +0000)
httemplate/search/cust_bill.cgi
patch
|
blob
|
history
diff --git
a/httemplate/search/cust_bill.cgi
b/httemplate/search/cust_bill.cgi
index
6eba4bd
..
f4ead70
100755
(executable)
--- a/
httemplate/search/cust_bill.cgi
+++ b/
httemplate/search/cust_bill.cgi
@@
-68,7
+68,7
@@
if ( $cgi->keywords ) {
die "unknown query string $query";
}
- my $extra_sql = scalar(@where) ? join(' AND ', @where) : '';
+ my $extra_sql = scalar(@where) ?
'WHERE '.
join(' AND ', @where) : '';
my $statement = "SELECT COUNT(*) FROM cust_bill $extra_sql";
my $sth = dbh->prepare($statement) or die dbh->errstr. " doing $statement";