Changeset 30277 for trunk/ippTools/share/regtool_checkburntoolimfile.sql

Timestamp:

Jan 14, 2011, 2:16:52 PM (15 years ago)

Author:

watersc1

Message:

checkburntool bugs: StringSubstitute still is broken, vague SQL. register_imfile.pl detected daytime wrong.

File:

• trunk/ippTools/share/regtool_checkburntoolimfile.sql (modified) (2 diffs)

trunk/ippTools/share/regtool_checkburntoolimfile.sql

@@ -1 +1 @@
 SELECT DISTINCT
-       exp_name,
+       summitExp.exp_name,
        rawImfile.uri,
        summitExp.dateobs AS registered,
@@ -31 +31 @@
              AND summitExp.dateobs <= '@DATEOBS_END@'
              AND summitImfile.class_id = '@CLASS_ID@'
-             AND (exp_name <= '@EXP_NAME@')                                                                     
+             AND (summitExp.exp_name <= '@EXP_NAME@')                                                                     
 ORDER BY summitExp.dateobs