1fc6b7d978483eb5a7f6509ec54479985de3bbf6
max
  Wed Jan 25 15:46:00 2012 -0800
trackDb changes for t2g
diff --git src/hg/hgc/t2g.c src/hg/hgc/t2g.c
index 98ace42..d7b5a15 100644
--- src/hg/hgc/t2g.c
+++ src/hg/hgc/t2g.c
@@ -18,30 +18,31 @@
 char* articleTable;
 
 /* splits string with | and returns part index (is there no easier way to do this?)
 char *splitPart(char* string, int index)
 {
     char* name2;
     name2 = cloneString(string);
     char **parts = NULL;
 	AllocArray(parts, 2);
     chopString(name2, "|", parts, 2);
     return (char *)parts[index];
 }*/
 
 void printMarkerSnippets(struct sqlConnection *conn, char* item)
 {
+sqlUpdate(conn, "SET SESSION group_concat_max_len = 10000");
 char query[4000];
 safef(query, sizeof(query), "SELECT distinct t2gElsevierMarker.articleId, url, title, authors, citation, group_concat(snippet SEPARATOR ' (...) ') FROM t2gElsevierMarker JOIN t2gElsevierArticle USING (articleId) WHERE markerId='%s' GROUP by articleId", item);
 
 struct sqlResult *sr = sqlGetResult(conn, query);
 printf("<H3>Snippets from Publications:</H3>");
 char **row;
 while ((row = sqlNextRow(sr)) != NULL)
     {
     char* articleId = row[0];
     char* url = row[1];
     char* title = row[2];
     char* authors = row[3];
     char* citation = row[4];
     char* snippets = row[5];
     printf("<SMALL>%s</SMALL><BR>", authors);