diff options
author | ivan <ivan> | 2003-11-03 05:57:28 +0000 |
---|---|---|
committer | ivan <ivan> | 2003-11-03 05:57:28 +0000 |
commit | d9c51bdc266798d01247e0ff72f6d64aefb91a2e (patch) | |
tree | a8691e10d9bcb01f7aed083a64e25bb5086ccb6a /httemplate/browse | |
parent | de38e11cb5a40c78ef5543f59f6ce968e7fd613b (diff) |
add suspended/canceled browse, fix the old suspended browse
Diffstat (limited to 'httemplate/browse')
-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 { |