MySql -Python question

2006-04-23 Thread ataanis
Hey all, I'm running a query within some python code, and I'm having
difficulties doing something that seems to be really simple . I'm
running a query in the following form:
query01 = 'select max(DirectorID) +1 from Director;'
cursor.execute(query01)
table = cursor.fetchall()
the resulting table , is a 1 row , 1 column table,showing 1 number and
I just need that number inside that table,and save it for a different
query,  but I can't get it , can anybody tell me the best way to do
this? thanks

-- 
http://mail.python.org/mailman/listinfo/python-list


Re: MySql -Python question

2006-04-24 Thread ataanis
both of your suggestions don't work, that's kind of what I was trying
the whole time

-- 
http://mail.python.org/mailman/listinfo/python-list