0a5052c6019c20ce851d2398ad339344afc32089
kent
  Thu Apr 4 19:30:37 2013 -0700
Added sqlQuickLongLong
diff --git src/hg/lib/jksql.c src/hg/lib/jksql.c
index 3e1bb3f..a3d4600 100644
--- src/hg/lib/jksql.c
+++ src/hg/lib/jksql.c
@@ -1553,30 +1553,45 @@
 int sqlQuickNum(struct sqlConnection *conn, char *query)
 /* Get numerical result from simple query */
 {
 struct sqlResult *sr;
 char **row;
 int ret = 0;
 
 sr = sqlGetResult(conn, query);
 row = sqlNextRow(sr);
 if (row != NULL && row[0] != NULL)
     ret = atoi(row[0]);
 sqlFreeResult(&sr);
 return ret;
 }
 
+long long sqlQuickLongLong(struct sqlConnection *conn, char *query)
+/* Get long long numerical result from simple query. Returns 0 if query not found */
+{
+struct sqlResult *sr;
+char **row;
+long long ret = 0;
+
+sr = sqlGetResult(conn, query);
+row = sqlNextRow(sr);
+if (row != NULL && row[0] != NULL)
+    ret = sqlLongLong(row[0]);
+sqlFreeResult(&sr);
+return ret;
+}
+
 double sqlQuickDouble(struct sqlConnection *conn, char *query)
 /* Get floating point numerical result from simple query */
 {
 struct sqlResult *sr;
 char **row;
 double ret = 0;
 
 sr = sqlGetResult(conn, query);
 row = sqlNextRow(sr);
 if (row != NULL && row[0] != NULL)
     ret = atof(row[0]);
 sqlFreeResult(&sr);
 return ret;
 }