Changeset 18698

Timestamp:

Jul 23, 2008, 4:33:23 PM (18 years ago)

Author:

Paul Price

Message:

Whoops --- exp_id isn't a string, but a S64, so I have to play games with it...

Location:

trunk/ippTools

Files:

• share/magictool_definebyquery_insert.sql (modified) (1 diff)
• src/magictool.c (modified) (1 diff)

trunk/ippTools/share/magictool_definebyquery_insert.sql

@@ -7 +7 @@
 FROM magicBestDiffs
 WHERE
-    exp_id = '%s'
+    exp_id = @EXP_ED@ -- Update this with the appropriate exp_id

trunk/ippTools/src/magictool.c

@@ -266 +266 @@
         // Create a suitable insertion query for this run
         psString thisInsert = psStringCopy(insert);
-        psString idString = NULL;
-        psStringAppend(&idString, "%" PRId64, magic_id);
-        psStringSubstitute(&thisInsert, idString, "@MAGIC_ID@");
-        psFree(idString);
+        {
+            psString idString = NULL;
+            psStringAppend(&idString, "%" PRId64, magic_id);
+            psStringSubstitute(&thisInsert, idString, "@MAGIC_ID@");
+            psFree(idString);
+        }
+        {
+            psString idString = NULL;
+            psStringAppend(&idString, "%" PRId64, exp_id);
+            psStringSubstitute(&thisInsert, idString, "@EXP_ID@");
+            psFree(idString);
+        }
 
         if (!p_psDBRunQuery(config->dbh, thisInsert, magic_id, exp_id)) {