[Pytrainer-svn] SF.net SVN: pytrainer:[691] pytrainer/trunk/pytrainer/record.py

[<jb...@us...>]

Revision: 691
          http://pytrainer.svn.sourceforge.net/pytrainer/?rev=691&view=rev
Author:   jblance
Date:     2010-11-10 22:01:21 +0000 (Wed, 10 Nov 2010)

Log Message:
-----------
Fixes for record filtering from Patrick

Modified Paths:
--------------
    pytrainer/trunk/pytrainer/record.py

Modified: pytrainer/trunk/pytrainer/record.py
===================================================================
--- pytrainer/trunk/pytrainer/record.py	2010-11-10 21:59:00 UTC (rev 690)
+++ pytrainer/trunk/pytrainer/record.py	2010-11-10 22:01:21 UTC (rev 691)
@@ -395,7 +395,7 @@
 		if not sport:
 			condition = "date>=\"%s\" and date<=\"%s\" and records.sport=sports.id_sports" %(date_ini,date_end)
 		else:
-			condition = "date>=\"%s\" and date<=\"%s\" and records.sport=sports.id_sports and sports.name=\"%s\"" %(date_ini,date_end, sport)
+			condition = "date>=\"%s\" and date<=\"%s\" and records.sport=sports.id_sports and sports.id_sports=\"%s\"" %(date_ini,date_end, sport)
 
 		return self.pytrainer_main.ddbb.select(tables,"date,distance,time,beats,comments,average,calories,maxspeed,maxbeats, sports.name", condition)
 
@@ -405,7 +405,7 @@
 			condition = "date>\"%s\" and date<\"%s\"" %(date_ini,date_end)
 		else :
 			tables = "records,sports"
-			condition = "date>\"%s\" and date<\"%s\" and records.sport=sports.id_sports and sports.name=\"%s\"" %(date_ini,date_end,sport)
+			condition = "date>\"%s\" and date<\"%s\" and records.sport=sports.id_sports and sports.id_sports=\"%s\"" %(date_ini,date_end,sport)
 
 		return self.pytrainer_main.ddbb.select(tables,
 					"date,distance,time,beats,comments,average,calories,maxspeed,maxbeats",


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.