aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLei Yan2016-11-18 21:16:53 +0000
committerLei Yan2016-11-18 21:16:53 +0000
commit1cae8e42f0f73718549b369cf0cd4d9f320e230e (patch)
tree12791ce696037d576c7adb9bc3412123a741f42a
parente6528ba528d14320322bcf9694c52879dedc418b (diff)
downloadgenenetwork2-1cae8e42f0f73718549b369cf0cd4d9f320e230e.tar.gz
Fix sql error: (GeneNetwork error: (_mysql_exceptions.OperationalError) (1054, "Unknown column 'mouse' in 'where clause'") [SQL: '\n select Geno)
-rw-r--r--wqflask/base/data_set.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/wqflask/base/data_set.py b/wqflask/base/data_set.py
index 918932fa..ae7fdcb5 100644
--- a/wqflask/base/data_set.py
+++ b/wqflask/base/data_set.py
@@ -724,8 +724,8 @@ class PhenotypeDataSet(DataSet):
if this_trait.lrs:
query = """
select Geno.Chr, Geno.Mb from Geno, Species
- where Species.Name = %s and
- Geno.Name = %s and
+ where Species.Name = '%s' and
+ Geno.Name = '%s' and
Geno.SpeciesId = Species.Id
""" % (species, this_trait.locus)
logger.sql(query)