From 385d4d7394dd0720129d6216c1b9089f83d75eb9 Mon Sep 17 00:00:00 2001 From: gsmselftest Date: Tue, 1 Nov 2011 22:38:49 +0100 Subject: iloging --- For Weekly Test/tricode/DbClass.py | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'For Weekly Test/tricode/DbClass.py') diff --git a/For Weekly Test/tricode/DbClass.py b/For Weekly Test/tricode/DbClass.py index 99c1e7c..a3bf486 100755 --- a/For Weekly Test/tricode/DbClass.py +++ b/For Weekly Test/tricode/DbClass.py @@ -301,12 +301,13 @@ class DBMySQLConnection: def maxTaskNo(self): if self.connectionCreated == 1: try: - self.cur.execute("SELECT MAX(taskNo) FROM TaskTable") - self.taskNo = self.cur.fetchone() + succ = self.cur.execute("SELECT taskNo FROM TaskTable") + taskNo = self.cur.fetchone() + self.taskNo = taskNo[0] if self.taskNo == None or self.taskNo == '0' or self.taskNo == '' or self.taskNo == 0: self.taskNo = 1 else: - self.taskNo = self.taskNo +1 + self.taskNo = int(self.taskNo) +1 return self.taskNo except MySQLdb.Error, e: @@ -390,4 +391,5 @@ class DBMySQLConnection: print str(e) return 3 else: - return 0 + return 0 + -- cgit v1.2.3-55-g7522