9318b2b63e004429cdce7c841143f6e7d9d41f5b
angie
  Fri Jun 20 15:14:58 2014 -0700
Added sqlQuickPairList for quick two-column queries.
diff --git src/hg/lib/jksql.c src/hg/lib/jksql.c
index 511b031..3ec4257 100644
--- src/hg/lib/jksql.c
+++ src/hg/lib/jksql.c
@@ -2086,30 +2086,44 @@
 {
 struct slDouble *list = NULL, *n;
 struct sqlResult *sr;
 char **row;
 sr = sqlGetResult(conn, query);
 while ((row = sqlNextRow(sr)) != NULL)
     {
     n = slDoubleNew(atof(row[0]));
     slAddHead(&list, n);
     }
 sqlFreeResult(&sr);
 slReverse(&list);
 return list;
 }
 
+struct slPair *sqlQuickPairList(struct sqlConnection *conn, char *query)
+/* Return a list of slPairs with the results of a two-column query.
+ * Free result with slPairFreeValsAndList. */
+{
+struct slPair *pairList = NULL;
+struct sqlResult *sr = sqlGetResult(conn, query);
+char **row;
+while ((row = sqlNextRow(sr)) != NULL)
+    slAddHead(&pairList, slPairNew(row[0], cloneString(row[1])));
+sqlFreeResult(&sr);
+slReverse(&pairList);
+return pairList;
+}
+
 
 int sqlTableSize(struct sqlConnection *conn, char *table)
 /* Find number of rows in table. */
 {
 char query[128];
 sqlSafef(query, sizeof(query), "SELECT COUNT(*) FROM %s", table);
 return sqlQuickNum(conn, query);
 }
 
 int sqlFieldIndex(struct sqlConnection *conn, char *table, char *field)
 /* Returns index of field in a row from table, or -1 if it
  * doesn't exist. */
 {
 struct sqlResult *sr;
 char **row;