Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 34104)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 34108)
@@ -549,5 +549,5 @@
 
         # 2 is hardwired -- convert to an enum (should probably read Ohana/src/libdvo/include/dvo.h defines
-        sql = "SELECT count(TYPE) FROM " + self.dvoPhotcodesTable + " WHERE TYPE = 2"
+        sql = "SELECT count(TYPE_AS_INT) FROM " + self.dvoPhotcodesTable + " WHERE TYPE_AS_INT = 2"
 
         filterCount = 0
@@ -567,6 +567,4 @@
     '''
     def getOrderedListOfFiltersFromPhotcodesTable(self, interestedFilters):
-
-        sql = "SELECT count(TYPE) FROM " + self.dvoPhotcodesTable + " WHERE TYPE = 'sec'"
 
         sql = "SELECT NAME FROM " + self.dvoPhotcodesTable + " WHERE "