Re: tuples and mysqldb tables

2005-09-19 Thread Python
I believe that the current version of MySQLdb supports: for row in cursor: id, protocol, name, description = row fall back on: for row in cursor.fetchall(): if the first suggestion fails. I'm not sure that this is clear from the DBI documentation. On Sun, 2005-09-18 at 17:53 -0400, Ed H

tuples and mysqldb tables

2005-09-18 Thread Ed Hotchkiss
I have used fetchall() to insert the values from a table into a tuple. anywhere from 0 - ? many rows could be in this tuple, so it is a row within a row. How do I use a loops to iterate through the nested tuple, and assign the tuples integers and strings to variables, ugh :P   The Tables data is l