Changeset 21119

Timestamp:

Jan 13, 2009, 3:28:52 PM (17 years ago)

Author:

Paul Price

Message:

Need to quote skycell_id.

File:

• trunk/tools/diff_inputs.pl (modified) (2 diffs)

trunk/tools/diff_inputs.pl

@@ -64 +64 @@
     "         OR warpSkyfile.warp_id = diffInputSkyfile.warp2)" .
     " WHERE diff_id = $diff_id";
-$sql .= " AND diffInputSkyfile.skycell_id = $skycell_id" if defined $skycell_id;
-$sql.= " UNION" .
+$sql .= " AND diffInputSkyfile.skycell_id = \'$skycell_id\'" if defined $skycell_id;
+$sql .= " UNION" .
     " SELECT" .
     "     NULL AS warp_path_base," .
@@ -75 +75 @@
     "         OR stackSumSkyfile.stack_id = diffInputSkyfile.stack2)" .
     " WHERE diff_id = $diff_id";
-$sql .= " AND diffInputSkyfile.skycell_id = $skycell_id" if defined $skycell_id;
+$sql .= " AND diffInputSkyfile.skycell_id = \'$skycell_id\'" if defined $skycell_id;