Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 32061)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 32062)
@@ -49,8 +49,10 @@
             rs = self.executeQuery(sql)
             rs.first()
-            return rs.getInt(1)
-        except:
-            self.logger.exception("No survey ID found for this survey: '" + self.survey + "'")
-            return -1
+            surveyID = rs.getInt(1)
+        except:
+            self.logger.errorPair("No survey ID found for survey", name)
+            surveyID = -1
+
+        return surveyID
 
     ''' 
@@ -67,5 +69,5 @@
             imageID = rs.getInt(1) 
         except: 
-            self.logger.exception("Unable to get imageID from dvo meta table using " + sql) 
+            self.logger.errorPair("Unable to get imageID from dvo using", sql) 
               
         return imageID 
@@ -84,5 +86,5 @@
             flags = rs.getInt(1)
         except:
-            self.logger.exception("Unable to get flags from dvo table using " + sql)
+            self.logger.errorPair("Unable to get flags from dvo using", sql)
         return flags
 
@@ -100,5 +102,5 @@
             photcode = rs.getInt(1)
         except:
-            self.logger.exception("Unable to get photcode from dvo table with: " + sql)
+            self.logger.errorPair("Unable to get photcode from dvo with", sql)
 
         return photcode
@@ -213,16 +215,16 @@
        sql = "CREATE TABLE " + self.dvoMetaTable + " LIKE dvoMeta"
        try: self.execute(sql)
-       except: self.logger.error("Unable to create table " + self.dvoMetaTable)
+       except: self.logger.errorPair("Unable to create table", self.dvoMetaTable)
 
        self.logger.infoPair("Creating table", self.dvoDetectionTable)
        sql = "CREATE TABLE " + self.dvoDetectionTable + " LIKE dvoDetection"
        try: self.execute(sql)
-       except: self.logger.error("Unable to create table " + self.dvoDetectionTable)
+       except: self.logger.errorPair("Unable to create table", self.dvoDetectionTable)
 
        self.logger.infoPair("Creating table", self.dvoDoneTable )
        sql = "CREATE TABLE " + self.dvoDoneTable + " (name VARCHAR(100))"
        try: self.execute(sql)
-       except: self.logger.error("Unable to create table " + self.dvoDoneTable)
-
-
-
+       except: self.logger.errorPair("Unable to create table", self.dvoDoneTable)
+
+
+