really fix notify for Pg 8.3
authorivan <ivan>
Tue, 31 Mar 2009 19:51:54 +0000 (19:51 +0000)
committerivan <ivan>
Tue, 31 Mar 2009 19:51:54 +0000 (19:51 +0000)
FS/FS/Cron/notify.pm

index c67fcc1..5b0e186 100644 (file)
@@ -62,7 +62,7 @@ END
       0 = ( select count(*) from cust_pkg_option
               where cust_pkg.pkgnum = cust_pkg_option.pkgnum
                 and cust_pkg_option.optionname = 'impending_recur_notification_sent'
-                and cust_pkg_option.optionvalue = 1
+                and CAST( cust_pkg_option.optionvalue AS INTEGER ) = 1
           )
 END