Changeset 28365

Timestamp:

Jun 16, 2010, 2:44:25 PM (16 years ago)

Author:

Paul Price

Message:

Fix advance queries.

Location:

trunk/ippTools

Files:

• share/diffphottool_advance.sql (modified) (1 diff)
• src/diffphottool.c (modified) (1 diff)

trunk/ippTools/share/diffphottool_advance.sql

@@ -9 +9 @@
     AND diffSkyfile.quality = 0
 -- WHERE hook %s
+GROUP BY diff_phot_id
 HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)

trunk/ippTools/src/diffphottool.c

@@ -428 +428 @@
         psS64 diff_phot_id = psMetadataLookupS64(NULL, row, "diff_phot_id");
 
-        const char *query = "UPDATE diffRun SET state = 'full' WHERE diff_id = %" PRId64;
+        const char *query = "UPDATE diffPhotRun SET state = 'full' WHERE diff_phot_id = %" PRId64;
         if (!p_psDBRunQueryF(config->dbh, query, diff_phot_id)) {
             psError(psErrorCodeLast(), false,