Changeset 24271 for trunk/ippScripts/scripts/ipp_serial_mops.pl

Timestamp:

May 27, 2009, 5:26:20 PM (17 years ago)

Author:

Paul Price

Message:

Don't CONVERT() the floating point value!

File:

• trunk/ippScripts/scripts/ipp_serial_mops.pl (modified) (1 diff)

trunk/ippScripts/scripts/ipp_serial_mops.pl

@@ -80 +80 @@
     MAX(diffWarps.diff_id) AS diff_id,
     -- The following trick pulls out the appropriate values for the maximum diff_id
-    CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY diffWarps.diff_id), ',', 1), UNSIGNED) AS zpt_obs,
+    SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY diffWarps.diff_id), ',', 1) AS zpt_obs,
     CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(diffWarps.inverse ORDER BY diffWarps.diff_id), ',', 1), UNSIGNED) AS inverse
 FROM (