6dd383de66888d8081a22ded91063bc5dc2d7061 hiram Thu Jan 26 16:22:17 2012 -0800 change rn4 table name of genes_rat to rgdGene2Raw diff --git src/hg/hgGene/synonym.c src/hg/hgGene/synonym.c index db6aa75..07dec71 100644 --- src/hg/hgGene/synonym.c +++ src/hg/hgGene/synonym.c @@ -181,31 +181,31 @@ *chp = ','; chp++; } return inStr; } static void rgdGene2SynonymPrint(struct section *section, struct sqlConnection *conn, char *rgdGeneId) { char *geneSym = NULL, *geneName = NULL; char query[256], **row; struct sqlResult *sr; if (rgdGeneId != NULL) { safef(query, sizeof(query), - "select old_symbol, old_name from genes_rat where gene_rgd_id = '%s'", + "select old_symbol, old_name from rgdGene2Raw where gene_rgd_id = '%s'", rgdGeneId+4L); sr = sqlGetResult(conn, query); if ((row = sqlNextRow(sr)) != NULL) { if (row[0][0] != 0 && !sameString(row[0], "n/a")) { geneSym = cloneString(row[0]); hPrintf("<B>Symbol:</B> %s ", addComma(row[0])); hPrintf("<BR>\n"); } if (row[1][0] != 0 && !sameString(row[0], "n/a")) { geneName = cloneString(row[1]); hPrintf("<B>Name:</B> %s ", addComma(geneName)); hPrintf("<BR>\n");