2dc6f1ab04207b985c79dbb696dce361bf515f3e braney Tue May 30 16:36:21 2023 -0700 add chromName to SELECT query for omimGene2 diff --git src/hg/hgTracks/simpleTracks.c src/hg/hgTracks/simpleTracks.c index 0b30103..119c35f 100644 --- src/hg/hgTracks/simpleTracks.c +++ src/hg/hgTracks/simpleTracks.c @@ -12790,31 +12790,31 @@ { if (slCount(genes) > 1) dyStringPrintf(dy, ", Synonyms: "); else dyStringPrintf(dy, ", Synonym: "); for(; genes; genes = genes->next) { dyStringPrintf(dy, "%s", genes->name); if (genes->next) dyStringPrintf(dy, ","); } } // now phenotype information sqlSafef(query,sizeof(query), - "select GROUP_CONCAT(omimPhenotype.description, '|',inhMode , '|',omimPhenoMapKey SEPARATOR '$') from omimGene2, omimGeneMap, omimPhenotype where omimGene2.name=omimGeneMap.omimId and omimGene2.name=omimPhenotype.omimId and omimGene2.name =%s", name); + "select GROUP_CONCAT(omimPhenotype.description, '|',inhMode , '|',omimPhenoMapKey SEPARATOR '$') from omimGene2, omimGeneMap, omimPhenotype where omimGene2.name=omimGeneMap.omimId and omimGene2.name=omimPhenotype.omimId and omimGene2.name =%s and omimGene2.chrom=\'%s\'", name, chromName); ret = sqlQuickQuery(conn, query, buf, sizeof(buf)); if (ret) { struct slName *phenotypes = slNameListFromString(ret, '$'); if (slCount(phenotypes)) { if (slCount(phenotypes) > 1) dyStringPrintf(dy, ", Phenotypes: "); else dyStringPrintf(dy, ", Phenotype: "); for(; phenotypes; phenotypes = phenotypes->next) { struct slName *components = slNameListFromString(phenotypes->name, '|');