Changeset 8768 for trunk


Ignore:
Timestamp:
11/28/07 13:43:14 (17 years ago)
Author:
Daniela Dorner
Message:
*** empty log message ***
Location:
trunk/MagicSoft/Mars/datacenter/db
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • trunk/MagicSoft/Mars/datacenter/db/builddatasets.php

    r8622 r8768  
    136136            $query0 = substr($query0, 0, -4);
    137137
    138         if (!empty($_GET["fZDMin"]) && !empty($_GET["fZDMax"]))
    139             $query0 .= "AND (fZenithDistanceMin > " . $_GET["fZDMin"] . " AND fZenithDistanceMax < " . $_GET["fZDMax"] . ") ";
     138        if ((!empty($_GET["fZDMin"]) || $_GET["fZDMin"]==0) && !empty($_GET["fZDMax"]))
     139            $query0 .= "AND (fZenithDistanceMin >= " . $_GET["fZDMin"] . " AND fZenithDistanceMax <= " . $_GET["fZDMax"] . ") ";
    140140
    141141        if (!empty($_GET["fSourceN"]))

  • trunk/MagicSoft/Mars/datacenter/db/findoffdata.php

    r8333 r8768  
    127127            $query0 = substr($query0, 0, -4);
    128128
    129         if (!empty($_GET["fZDMin"]) && !empty($_GET["fZDMax"]))
    130             $query0 .= "AND (fZenithDistanceMin > " . $_GET["fZDMin"] . " AND fZenithDistanceMax < " . $_GET["fZDMax"] . ") ";
     129        if ((!empty($_GET["fZDMin"]) || $_GET["fZDMin"]==0) && !empty($_GET["fZDMax"]))
     130            $query0 .= "AND (fZenithDistanceMin >= " . $_GET["fZDMin"] . " AND fZenithDistanceMax <= " . $_GET["fZDMax"] . ") ";
    131131
    132132        if (!empty($_GET["fSourceN"]))

  • trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php

    r8467 r8768  
    103103            $query0 .= "RunData.fRunNumber BETWEEN " . $_GET["fRunMin"] . " AND " . $_GET["fRunMax"] . " ";
    104104
    105         if (!empty($_GET["fZDMin"]) && !empty($_GET["fZDMax"]))
     105        if ((!empty($_GET["fZDMin"]) || $_GET["fZDMin"]==0) && !empty($_GET["fZDMax"]))
    106106            $query0 .= "AND fZenithDistance BETWEEN " . $_GET["fZDMin"] . " AND  " . $_GET["fZDMax"] . " ";
    107107

  • trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php

    r8476 r8768  
    140140            $query0 = substr($query0, 0, -4);
    141141
    142         if (!empty($_GET["fZDMin"]) && !empty($_GET["fZDMax"]))
    143             $query0 .= "AND (fZenithDistanceMin > " . $_GET["fZDMin"] . " AND fZenithDistanceMax < " . $_GET["fZDMax"] . ") ";
     142        if ((!empty($_GET["fZDMin"]) || $_GET["fZDMin"]==0) && !empty($_GET["fZDMax"]))
     143            $query0 .= "AND (fZenithDistanceMin >= " . $_GET["fZDMin"] . " AND fZenithDistanceMax <= " . $_GET["fZDMax"] . ") ";
    144144
    145145        if (!empty($_GET["fSourceN"]))
Note: See TracChangeset for help on using the changeset viewer.