Walking through a mysql db
Jeff Elkins
jeffelkins at earthlink.net
Sat Jun 4 09:24:25 EDT 2005
I'm writing a small wxpython app to display and update a dataset. So far, I
get the first record for display:
try:
cursor = conn.cursor ()
cursor.execute ("SELECT * FROM dataset")
item = cursor.fetchone ()
Now, how do I step through the dataset one row at a time? My form has 'next'
and 'back' buttons, and I'd like them to step forward or back, fetching the
appropriate row in the table. I've tried setting cursor.rownumber by
incrementing it prior to the fetchone() w/o effect.
Thanks for any pointers.
Jeff Elkins
More information about the Python-list
mailing list