78349c78059d29f80919916fdbf82416333fd473
chinhli
  Fri Apr 11 16:20:24 2014 -0700
Feed back from CR #13033Rename geneReviewsGeneGRshortNBKidGRtitle to geneReviewsDetail
Add a comment in the geneReviewsGrshortNBKid.sql and geneReviewsGrshortTitleNBKid.sql
to let reader know they are temp files used by track build.

diff --git src/hg/hgc/hgc.c src/hg/hgc/hgc.c
index 3020917..fe73b1d 100644
--- src/hg/hgc/hgc.c
+++ src/hg/hgc/hgc.c
@@ -9914,31 +9914,31 @@
 	while ((row = sqlNextRow(sr)) != NULL)
 	    {
 	    if (printedCnt < 1)
 		printf("<B>Related UCSC Gene(s): </B>");
 	    else
 		printf(", ");
             printf("<A HREF=\"%s%s&hgg_chrom=none\">", "../cgi-bin/hgGene?hgg_gene=", row[0]);
             printf("%s</A></B>", row[0]);
 	    printedCnt++;
 	    }
         if (printedCnt >= 1) printf("<BR>\n");
 	}
     sqlFreeResult(&sr);
 
     // show GeneReviews  link(s)
-    if (sqlTableExists(conn, "geneReviewsGeneGRshortNBKidGRtitle"))
+    if (sqlTableExists(conn, "geneReviewsDetail"))
         {
         sqlSafef(query, sizeof(query),
           "select distinct r.name2 from refLink l, omim2gene g, refGene r where l.omimId=%s and g.geneId=l.locusLinkId and g.entryType='gene' and chrom='%s' and txStart = %s and txEnd= %s",
         itemName, chrom, chromStart, chromEnd);
         sr = sqlMustGetResult(conn, query);
         if (sr != NULL)
             {
             while ((row = sqlNextRow(sr)) != NULL)
                 {
                 prGRShortRefGene(row[0]);
                 }
             }
         sqlFreeResult(&sr);
         }