Changeset 24758

Timestamp:

Jul 12, 2009, 10:48:52 AM (17 years ago)

Author:

eugene

Message:

RA & DEC based ranges should be in degrees not radians; convert in the query

File:

• trunk/ippMonitor/scripts/generate (modified) (1 diff)

trunk/ippMonitor/scripts/generate

@@ -308 +308 @@
         if ($value eq "*") { next; }
         if ($format[$i] eq "%s") {
-            print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'string');\n";
-        } else {
-            print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'string');\n";
-            print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'min');\n";
-            print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'max');\n";
-        }
+            print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'string', 1.0);\n";
+            next;
+        } 
+        if ($format[$i] eq "%C") {
+            # convert the RA & DEC limits to radians for comparison
+            print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'min', 0.017453);\n";
+            print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'max', 0.017453);\n";
+            next;
+        } 
+        print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'string', 1.0);\n";
+        print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'min', 1.0);\n";
+        print FILE "\$WHERE = check_restrict ('$value', \$WHERE, 'max', 1.0);\n";
     }
     print FILE "\$WHERE = check_ordering ('$GROUPS', \$WHERE);\n";