diff options
| -rwxr-xr-x | httemplate/search/cust_pkg.cgi | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/httemplate/search/cust_pkg.cgi b/httemplate/search/cust_pkg.cgi index 84b083a3d..4fd5e9d45 100755 --- a/httemplate/search/cust_pkg.cgi +++ b/httemplate/search/cust_pkg.cgi @@ -225,11 +225,11 @@ foreach my $field (qw( setup last_bill bill susp expire cancel )) { or $disable{$cgi->param('status')}->{$field}; push @where, - "$field IS NOT NULL", - "$field >= $beginning", - "$field <= $ending"; + "cust_pkg.$field IS NOT NULL", + "cust_pkg.$field >= $beginning", + "cust_pkg.$field <= $ending"; - $orderby ||= "ORDER BY $field"; + $orderby ||= "ORDER BY cust_pkg.$field"; } |