summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/tricode/DbClass.py
diff options
context:
space:
mode:
Diffstat (limited to 'For Weekly Test/tricode/DbClass.py')
-rwxr-xr-xFor Weekly Test/tricode/DbClass.py10
1 files changed, 6 insertions, 4 deletions
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
+