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
