Index: trunk/ippToPsps/jython/scratchdb.py
===================================================================
--- trunk/ippToPsps/jython/scratchdb.py	(revision 39544)
+++ trunk/ippToPsps/jython/scratchdb.py	(revision 40011)
@@ -186,4 +186,29 @@
               
         return imageID 
+
+    ''' 
+    Gets imageID from extern ID and photcoderange (needed for FW, possibly for others)
+    ''' 
+    def getImageIDFromExternIDandPhotcodeRange(self, externID, r1, r2): 
+               
+        imageID = -1 
+               
+        sql1 = "SELECT IMAGE_ID FROM " + self.dvoImagesTable + " WHERE EXTERN_ID = %s" % (externID) 
+        range = " AND PHOTCODE >= " + str(r1) +" AND PHOTCODE <=" + str(r2)
+        sql = sql1 + range
+
+        self.logger.info(sql)
+        try: 
+            rs = self.executeQuery(sql)   
+            rs.first() 
+            imageID = rs.getInt(1) 
+        except: 
+            self.logger.errorPair("Unable to get imageID from dvo using", sql) 
+              
+        return imageID 
+
+
+
+
 
     '''