Changeset 9108 for trunk

Timestamp:

08/07/08 12:23:05 (16 years ago)

Author:

tbretz

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/macros/buildsequenceentries.C (modified) (2 diffs)

trunk/MagicSoft/Mars/Changelog

@@ -18 +18 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2008/08/07 Thomas Bretz
+
+   * datacenter/macros/buildsequenceentries.C:
+     - fixed a problem with the check whether a sequence already
+       exists. It was always belived that the sequence doesn't exist.
+
+
 
  2008/08/07 Stefan Ruegamer

trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C

@@ -469 +469 @@
         const char *fmt2 = "AND fExcludedFDAKEY=1 AND (fRunTypeKEY BETWEEN 2 AND 4) ORDER BY Id";
 
-        const TString query1 = Form("%s fTelescopeNumber=%d AND fSequenceFirst=%d %s",                             fmt1, fTelescopeNumber, runstart/1000, fTelescopeNumber, fmt2);
+        const TString query1 = Form("%s fTelescopeNumber=%d AND fSequenceFirst=%d %s",                             fmt1, fTelescopeNumber, runstart/1000,     fmt2);
         const TString query2 = Form("%s fTelescopeNumber=%d AND fRunNumber*1000+fFileNumber BETWEEN %d AND %d %s", fmt1, fTelescopeNumber, runstart, runstop, fmt2);
 
@@ -510 +510 @@
                  " fTelescopeNumber=%d AND fSequenceFirst>0 AND "
                  " fExcludedFDAKEY=1 AND (fRunTypeKEY BETWEEN 2 AND 4)"
-                 " GROUP BY fSequenceFirst", fTelescopeNumber, runstart, runstop);
+                 " GROUP BY fSequenceFirst", runstart, runstop,
+                 fTelescopeNumber);
 
         TSQLResult *res = Query(query);