diff options
| author | ivan <ivan> | 2002-07-07 13:25:12 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-07-07 13:25:12 +0000 |
| commit | 6a22335d0376846dfbbfda0bb952719b30ce2d30 (patch) | |
| tree | 7b6838f7d611469a9cfdfa45040ce0d1c4313fc7 /httemplate | |
| parent | c89d696aae0a695b107e7c20ac06aa4b5e69cdac (diff) | |
don't forget to where the where clause
Diffstat (limited to 'httemplate')
| -rwxr-xr-x | httemplate/search/cust_bill.cgi | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/search/cust_bill.cgi b/httemplate/search/cust_bill.cgi index 6eba4bd49..f4ead7042 100755 --- 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"; |