Index: /trunk/ippToPsps/jython/mysql.py
===================================================================
--- /trunk/ippToPsps/jython/mysql.py	(revision 31379)
+++ /trunk/ippToPsps/jython/mysql.py	(revision 31380)
@@ -106,4 +106,18 @@
 
     '''
+    Reports the number of rows with this columns set as this numeric value and then deletes them 
+    '''
+    def reportAndDeleteRowsWithThisValue(self, tableName, columnName, value):
+
+        sql = "SELECT COUNT(*) FROM " + tableName + " WHERE " + columnName + " = " + value
+        rs = self.stmt.executeQuery(sql)
+        rs.first()
+        nBadFlux = rs.getInt(1)
+        self.logger.info("%d NULL %s values in table %s. Deleting." % (nBadFlux, columnName, tableName))
+
+        sql="DELETE from " + tableName + " WHERE " + columnName + " = " + value
+        self.stmt.execute(sql)
+
+    '''
     Reports the number of rows with this column NULL and then deletes them 
     '''