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

Reply via email to