From 5f8ffd072989b5fe0fc1e561f062bdc4dc799631 Mon Sep 17 00:00:00 2001 From: zsloan Date: Thu, 22 Sep 2022 21:08:19 +0000 Subject: Fix bug in GeneUtil.py query where extra quotes caused an error --- wqflask/wqflask/interval_analyst/GeneUtil.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wqflask/wqflask/interval_analyst/GeneUtil.py b/wqflask/wqflask/interval_analyst/GeneUtil.py index 780a4db1..1da93b42 100644 --- a/wqflask/wqflask/interval_analyst/GeneUtil.py +++ b/wqflask/wqflask/interval_analyst/GeneUtil.py @@ -70,7 +70,7 @@ def loadGenes(chrName, diffCol, startMb, endMb, species='mouse'): cursor.execute( f"SELECT {', '.join(fetchFields)} FROM GeneList WHERE " "SpeciesId = %s AND " - "geneSymbol= '%s' LIMIT 1", + "geneSymbol= %s LIMIT 1", (othSpecId, newdict["GeneSymbol"])) resultsOther = cursor.fetchone() -- cgit v1.2.3