Changeset 18802 for trunk/www/db_po/insert_po.php

Timestamp:

04/03/17 05:25:30 (8 years ago)

Author:

Daniela Dorner

Message:

adapted to change of column fValidFrom in DB

File:

• trunk/www/db_po/insert_po.php (modified) (2 diffs)

trunk/www/db_po/insert_po.php

@@ -190 +190 @@
         $query0.=" WHERE fIndex=".$_GET["fIndex"];
     if ($_GET["fUpdCase"]==6)
-        $query0.=" AND fValidFrom='0000-00-00 00:00:00'";
+        $query0.=" AND fValidFrom='1970-01-01 00:00:00'";
     $query0.=";";
 
@@ -204 +204 @@
         if ($_GET["fUpdCase"]==3 || $_GET["fUpdCase"]==4)
             $query0.=" AND NOT fIndex=".$_GET["fIndex"];
-        $query0.=" AND ((NOT ISNULL(fValue) AND NOT fValidFrom='0000-00-00 00:00:00') ";//normal entries, but not deleted ones
-        $query0.=" OR (ISNULL(fValue) AND fValidFrom='0000-00-00 00:00:00')); ";//new entries
+        $query0.=" AND ((NOT ISNULL(fValue) AND NOT fValidFrom='1970-01-01 00:00:00') ";//normal entries, but not deleted ones
+        $query0.=" OR (ISNULL(fValue) AND fValidFrom='1970-01-01 00:00:00')); ";//new entries
 
         //insert new counter to history