$pvf isn't a global.

[freeside.git] / httemplate / browse / part_pkg.cgi

diff --git a/httemplate/browse/part_pkg.cgi b/httemplate/browse/part_pkg.cgi
index 044ba46..efaa59e 100755 (executable)
--- 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 {
@@ -119,12 +119,12 @@ END
 
     $suspended_sth->execute( $part_pkg->pkgpart ) or die $suspended_sth->errstr;
     my $num_suspended = $suspended_sth->fetchrow_arrayref->[0];
-    print '<FONT COLOR="#FF9900"<B>'. $num_suspended.
+    print '<FONT COLOR="#FF9900"><B>'. $num_suspended.
           qq!</B></FONT>&nbsp;<A HREF="${p}search/cust_pkg.cgi?magic=suspended;pkgpart=$hashref->{pkgpart}">suspended</A><BR>!;
 
     $canceled_sth->execute( $part_pkg->pkgpart ) or die $canceled_sth->errstr;
     my $num_canceled = $canceled_sth->fetchrow_arrayref->[0];
-    print '<FONT COLOR="#FF0000"<B>'. $num_canceled.
+    print '<FONT COLOR="#FF0000"><B>'. $num_canceled.
           qq!</B></FONT>&nbsp;<A HREF="${p}search/cust_pkg.cgi?magic=canceled;pkgpart=$hashref->{pkgpart}">canceled</A>!;