Changeset 8168 for trunk/MagicSoft/Mars/datacenter

Timestamp:

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

Author:

tbretz

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C (modified) (1 diff)

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 ";