src/hg/hgGene/ctd.c 1.9

Index: src/hg/hgGene/ctd.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/hgGene/ctd.c,v
retrieving revision 1.8
retrieving revision 1.9
diff -b -B -U 1000000 -r1.8 -r1.9
--- src/hg/hgGene/ctd.c	3 Sep 2008 19:18:49 -0000	1.8
+++ src/hg/hgGene/ctd.c	13 Feb 2009 02:38:27 -0000	1.9
@@ -1,116 +1,116 @@
 /* ctd - do CTD section. */
 
 #include "common.h"
 #include "hash.h"
 #include "linefile.h"
 #include "dystring.h"
 #include "cheapcgi.h"
 #include "spDb.h"
 #include "hgGene.h"
 #include "hdb.h"
 #include "net.h"
 
 static char const rcsid[] = "$Id$";
 
 static boolean ctdExists(struct section *section, 
 	struct sqlConnection *conn, char *geneId)
 /* Return TRUE if CTD database exists and it has an entry with the gene symbol */
 {
 char condStr[255];
 char *geneSymbol;
 if (sqlTableExists(conn, "kgXref") == FALSE) return FALSE;
 
 if (sqlTableExists(conn, "hgFixed.ctdSorted") == TRUE)
     {
     safef(condStr, sizeof(condStr), "x.geneSymbol=c.GeneSymbol and kgId='%s' limit 1", geneId);
     geneSymbol = sqlGetField(database, "kgXref x, hgFixed.ctdSorted c", 
     			     "ChemicalId", condStr);
     if (geneSymbol != NULL) return(TRUE);
     }
 return(FALSE);
 }
 
 static void ctdPrint(struct section *section, 
 	struct sqlConnection *conn, char *geneId)
 /* Print out CTD section. */
 {
 char query[256];
 struct sqlResult *sr;
 char **row;
 char *chemId, *chemName;
 int chemCnt;
 int first = 1;
 boolean showCompleteCtdList;
 struct dyString *currentCgiUrl;
 
 showCompleteCtdList = FALSE;
 if (cgiOptionalString("showAllCtdRef") != NULL)
     {
     if (sameWord(cgiOptionalString("showAllCtdRef"), "Y") ||
 	sameWord(cgiOptionalString("showAllCtdRef"), "y") )
 	{
 	showCompleteCtdList = TRUE;
 	}
     cartRemove(cart, "showAllCtdRef");
     }
 currentCgiUrl = cgiUrlString();
     
 /* List chemicals related to this gene */
 safef(query, sizeof(query),
      "select ChemicalId, ChemicalName from kgXref x, hgFixed.ctdSorted c where x.geneSymbol=c.GeneSymbol and kgId='%s'", geneId);
 
 sr = sqlMustGetResult(conn, query);
 row = sqlNextRow(sr);
     
 chemCnt = 0;
 while (row != NULL) 
     {
     chemId   = cloneString(row[0]);
     chemName = cloneString(row[1]);
    
     if (first)
     	{
 	printf("<B>The following chemicals interact with this gene</B>\n");
 	printf("<UL>");
 	first = 0;
 	}
     
     printf("<LI><A HREF=\"http://ctd.mdibl.org/detail.go?type=chem&acc=%s\" target=_blank>", 
     	   chemId);
-    printf("%s</B></A>\n", chemId);
-    printf("%s\n", chemName);fflush(stdout);
+    printf("%s</A>\n", chemId);
+    printf("%s\n", chemName);
     printf("</LI>");	
     chemCnt++;
     row = sqlNextRow(sr);
     /* Initially, just show no more than 10 items */
     if ((!showCompleteCtdList) && (chemCnt >= 10) && (row != NULL))
 	{
 	chemCnt++;
 	break;
 	}
     }
 sqlFreeResult(&sr);
 
 if (!first) printf("</UL>");
 
 /* Offer user the option to see the complete list */
 if ((!showCompleteCtdList) && chemCnt > 10)
     {
     printf("<B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; more ...  </B>");
     printf("<A HREF=\"%s?showAllCtdRef=Y&%s&#35;ctd\">click here to view the complete list</A> " 
 	   ,"hgGene", currentCgiUrl->string);
     }
 
 return;
 }
 
 struct section *ctdSection(struct sqlConnection *conn, 
 	struct hash *sectionRa)
 /* Create CTD section. */
 {
 struct section *section = sectionNew(sectionRa, "ctd");
 section->exists = ctdExists;
 section->print = ctdPrint;
 return section;
 }