diff options
| -rwxr-xr-x | httemplate/search/cust_pay.cgi | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/httemplate/search/cust_pay.cgi b/httemplate/search/cust_pay.cgi index d601617f9..7a983703f 100755 --- a/httemplate/search/cust_pay.cgi +++ b/httemplate/search/cust_pay.cgi @@ -23,8 +23,9 @@ if ( $cgi->param('magic') && $cgi->param('magic') eq '_date' ) { my $ending = str2time($1) + 86400; $range .= ( $range ? ' AND ' : ' WHERE ' ). " _date <= $ending "; } + $range =~ s/^\s*WHERE/ AND/ if scalar(keys %search) ; - @cust_pay = qsearch('cust_pay', \%search, '', " $range" ); + @cust_pay = qsearch('cust_pay', \%search, '', $range ); $sortby = \*date_sort; |