Changeset 9372 for trunk/ippTools/src/detselect.c

Timestamp:

Oct 6, 2006, 3:25:34 PM (20 years ago)

Author:

jhoblitt

Message:

limit -search to one result
minor code tiding

File:

• trunk/ippTools/src/detselect.c (modified) (3 diffs)

trunk/ippTools/src/detselect.c

@@ -52 +52 @@
     psString query = psStringCopy(
         "SELECT"
-        " detNormalizedImfile.det_id,"
-        " detNormalizedImfile.iteration,"
-        " detNormalizedImfile.class_id"
+        "   detNormalizedImfile.det_id,"
+        "   detNormalizedImfile.iteration,"
+        "   detNormalizedImfile.class_id"
         " FROM detRun"
         " JOIN detInputExp"
@@ -78 +78 @@
         psFree(whereClause);
     }
+
+    psStringAppend(&query, " LIMIT 1");
 
     if (!p_psDBRunQuery(config->dbh, query)) {
@@ -125 +127 @@
 
     psString query = psStringCopy(
-        "SELECT detNormalizedImfile.*"
+        "SELECT DISTINCT"
+        "   detNormalizedImfile.*"
         " FROM detNormalizedImfile"
         " JOIN detRun"