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
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