Changeset 8168 for trunk/MagicSoft

Timestamp:

10/27/06 14:07:01 (18 years ago)

Author:

tbretz

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

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

trunk/MagicSoft/Mars/Changelog

@@ -18 +18 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2006/10/27 Thomas Bretz
+
+   * datacenter/macros/buildsequenceentries.C:
+     - included a fix for 0000-00-00 times in the run-database
+
+
 
  2006/10/26 Daniela Dorner

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

@@ -294 +294 @@
         query += " MIN(fZenithDistance), MAX(fZenithDistance), ";
         query += " MIN(fAzimuth), MAX(fAzimuth), ";
-        query += " MIN(fRunStart), MAX(fRunStop), ";
+        query += " MIN(if(fRunStart=0,NULL,fRunStart), ";
+        query += " MAX(if(fRunStop=0,NULL,fRunStop), ";
         query += " ELT(MAX(FIELD(fLightConditionsKEY, 1, 2, 7, 5, 8)), 1, 2, 7, 5, 8) ";
         query += " FROM RunData WHERE ";