Jeff Elkins wrote: > 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. You could either execute N-1 fetchone()s before you fetch the Nth dataset (with N starting at 1) or use the 'LIMIT' feature of MySQL: cursor.execute ("SELECT * FROM dataset LIMIT %s,1", n) where n is the index of the requested dataset (starting at 0)
-- Benjamin Niemann Email: pink at odahoda dot de WWW: http://www.odahoda.de/ -- http://mail.python.org/mailman/listinfo/python-list