From 1cae8e42f0f73718549b369cf0cd4d9f320e230e Mon Sep 17 00:00:00 2001
From: Lei Yan
Date: Fri, 18 Nov 2016 21:16:53 +0000
Subject: Fix sql error: (GeneNetwork error:
 (_mysql_exceptions.OperationalError) (1054, "Unknown column 'mouse' in 'where
 clause'") [SQL: '\n select Geno)

---
 wqflask/base/data_set.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'wqflask')

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)
-- 
cgit v1.2.3