diff options
| author | zsloan | 2022-09-22 21:08:19 +0000 |
|---|---|---|
| committer | zsloan | 2022-09-22 21:10:29 +0000 |
| commit | 5f8ffd072989b5fe0fc1e561f062bdc4dc799631 (patch) | |
| tree | 0163d247abf641580f39f1735dccc6a5ab4ade33 | |
| parent | 07661315b8e92de22bcea3434c101663b2235c12 (diff) | |
| download | genenetwork2-5f8ffd072989b5fe0fc1e561f062bdc4dc799631.tar.gz | |
Fix bug in GeneUtil.py query where extra quotes caused an error
| -rw-r--r-- | wqflask/wqflask/interval_analyst/GeneUtil.py | 2 |
1 files changed, 1 insertions, 1 deletions
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() |