Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 38995)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 39027)
@@ -190,10 +190,11 @@
 
         sql = "SELECT FLAGS FROM " + self.dvoImagesTable + " WHERE EXTERN_ID = %s" % (externID)
-        try:
-            rs = self.executeQuery(sql)  
-            rs.first()
+        rs = self.executeQuery(sql)  
+
+        if not rs.first():
+            self.logger.errorPair("Unable to get flags from dvo using", sql)
+        else:
             flags = rs.getInt(1)
-        except:
-            self.logger.errorPair("Unable to get flags from dvo using", sql)
+
         return flags
 
@@ -206,11 +207,29 @@
 
         sql = "SELECT PHOTCODE FROM " + self.dvoImagesTable + " WHERE EXTERN_ID = %s" % (externID)
-        try:
-            rs = self.executeQuery(sql)  
-            rs.first()
+        rs = self.executeQuery(sql)  
+
+        if not rs.first():
+            self.logger.errorPair("Unable to get photcode from dvo with", sql)
+        else:
             photcode = rs.getInt(1)
-        except:
-            self.logger.errorPair("Unable to get photcode from dvo with", sql)
-
+
+        return photcode
+
+    '''
+    Gets photcode (aka photoCalID from dvo table)
+    '''
+    def getPhotcodeByName(self, photcodeName):
+
+        photcode = -1
+
+        sql = "SELECT CODE FROM %s WHERE NAME = '%s'" % (self.dvoPhotcodesTable, photcodeName)
+        rs = self.executeQuery(sql)  
+
+        if not rs.first():
+            self.logger.errorPair("No photcode found for ", photcodeName)
+            print "--- sql: " + sql
+            os._exit(2)
+
+        photcode = rs.getInt(1)
         return photcode