Index: trunk/ippToPsps/jython/detectionbatch.py
===================================================================
--- trunk/ippToPsps/jython/detectionbatch.py	(revision 38228)
+++ trunk/ippToPsps/jython/detectionbatch.py	(revision 38237)
@@ -323,6 +323,7 @@
 
         sqlLine.group("frameID",          str(self.expID))
-        sqlLine.group("magref",           self.getKeyFloat(header,"%.8f","MAGREF")
+        sqlLine.group("magref",           self.getKeyFloat(header,"%.8f","MAGREF"))
         sql = sqlLine.make(") VALUES ( ", ")")
+                      
         try: self.scratchDb.execute(sql)
         except:
@@ -340,10 +341,10 @@
                       stringint.rjust(2, '0')
                       sqlLine = sqlUtility("INSERT INTO " + tableName + "(")
-                      sqlLine.group("offset"+stringint", "OFFSET")
-                      sqlLine.group("counts"+stringint", "COUNTS")
-                      sqlLine.group("diffMean"+stringint", "DIFF.MEAN")
-                      sqlLine.group("diffStdev01"+stringint", "DIFF.STDEV")
-                      sqlLine.group("errMean01"+stringing", "ERR.MEAN")
-                      sql = sqlLine.makeRaw(") SELECT ", "FROM " + ippTableName + " WHERE table_index = " + str(i)")
+                      sqlLine.group("offset"+stringint, "OFFSET")
+                      sqlLine.group("counts"+stringint, "COUNTS")
+                      sqlLine.group("diffMean"+stringint, "DIFF.MEAN")
+                      sqlLine.group("diffStdev01"+stringint, "DIFF.STDEV")
+                      sqlLine.group("errMean01"+stringing, "ERR.MEAN")
+                      sql = sqlLine.makeRaw(") SELECT ", "FROM " + ippTableName + " WHERE table_index = " + str(i))
                       try: self.scratchDb.execute(sql)
                       except: