7e88d971aeed23ac14b271ba65bbc2d0514d0378 galt Tue Jan 30 01:19:50 2018 -0800 little cleanup. diff --git src/hg/lib/visiGene.c src/hg/lib/visiGene.c index e9c203b..ab836b0 100644 --- src/hg/lib/visiGene.c +++ src/hg/lib/visiGene.c @@ -676,32 +676,32 @@ sqlDyStringPrintf(dy, "select gene from geneSynonym where name "); appendMatchHow(dy, name, how); sr = sqlGetResult(conn, dy->string); while ((row = sqlNextRow(sr)) != NULL) { geneEl = slNameNew(row[0]); slAddHead(&geneList, geneEl); } slReverse(&geneList); sqlFreeResult(&sr); for (geneEl = geneList; geneEl != NULL; geneEl = geneEl->next) { dyStringClear(dy); sqlDyStringPrintf(dy, "select imageProbe.image from probe,imageProbe"); - dyStringPrintf(dy, " where probe.gene = %s ", geneEl->name); - dyStringAppend(dy, " and probe.id = imageProbe.probe"); + sqlDyStringPrintf(dy, " where probe.gene = %s ", geneEl->name); + sqlDyStringPrintf(dy, " and probe.id = imageProbe.probe"); sr = sqlGetResult(conn, dy->string); while ((row = sqlNextRow(sr)) != NULL) { char *ids = row[0]; if (!hashLookup(uniqHash, ids)) { hashAdd(uniqHash, ids, NULL); imageEl = slIntNew(sqlUnsigned(ids)); slAddHead(&imageList, imageEl); } } sqlFreeResult(&sr); } dyStringFree(&dy); hashFree(&uniqHash);