diff options
| author | ivan <ivan> | 2007-04-23 23:34:52 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2007-04-23 23:34:52 +0000 |
| commit | 6191812cbe465d93cf322d64bc525d299530e4a9 (patch) | |
| tree | 84dc68065b82b734a3bcb33892b6cc05e4f52460 /httemplate | |
| parent | 0ddbeb00fa8c2d777d8344ee690054bb7d382c6c (diff) | |
fix error: column reference "fieldname" is ambiguous
Diffstat (limited to 'httemplate')
| -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"; } |