diff options
| author | ivan <ivan> | 2003-11-03 05:57:26 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-11-03 05:57:26 +0000 |
| commit | a237d07ba60588f45047e5d0f7950a5f678a7fdf (patch) | |
| tree | 6ae2b5d8b781d5e4b15bd6837c7cd0d53ec76cd0 /httemplate/browse/part_pkg.cgi | |
| parent | 6e6072dc95598df97f9c7ac3fd8b2afb75ebd4a6 (diff) | |
add suspended/canceled browse, fix the old suspended browse
Diffstat (limited to 'httemplate/browse/part_pkg.cgi')
| -rwxr-xr-x | httemplate/browse/part_pkg.cgi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/browse/part_pkg.cgi b/httemplate/browse/part_pkg.cgi index 9dc8860fb..efaa59e00 100755 --- a/httemplate/browse/part_pkg.cgi +++ b/httemplate/browse/part_pkg.cgi @@ -32,12 +32,12 @@ if ( $cgi->param('active') ) { $suspended_sth = dbh->prepare( 'SELECT COUNT(*) FROM cust_pkg WHERE pkgpart = ?'. ' AND ( cancel IS NULL OR cancel = 0 )'. - ' AND susp IS NOT NULL AND susp > 0' + ' AND susp IS NOT NULL AND susp != 0' ) or die dbh->errstr; $canceled_sth = dbh->prepare( 'SELECT COUNT(*) FROM cust_pkg WHERE pkgpart = ?'. - ' AND cancel IS NOT NULL AND cancel > 0' + ' AND cancel IS NOT NULL AND cancel != 0' ) or die dbh->errstr; } else { |