src/hg/lib/jksql.c 1.139

Index: src/hg/lib/jksql.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/jksql.c,v
retrieving revision 1.138
retrieving revision 1.139
diff -b -B -U 4 -r1.138 -r1.139
--- src/hg/lib/jksql.c	16 Oct 2009 00:06:02 -0000	1.138
+++ src/hg/lib/jksql.c	18 Mar 2010 01:50:29 -0000	1.139
@@ -1351,8 +1351,17 @@
 	table, field, key);
 return sqlQuickNum(conn, query) > 0;
 }
 
+int sqlRowCount(struct sqlConnection *conn, char *queryTblAndCondition)
+/* Return count of rows that match condition. The queryTblAndCondition
+ * should contain everying after "select count(*) FROM " */
+{
+char query[256];
+safef(query, sizeof(query), "select count(*) from %s",queryTblAndCondition);
+return sqlQuickNum(conn, query);
+}
+
 
 struct sqlResult *sqlStoreResult(struct sqlConnection *sc, char *query)
 /* Returns NULL if result was empty.  Otherwise returns a structure
  * that you can do sqlRow() on.  Same interface as sqlGetResult,