Re: Cursor navigation

2005-07-22 Thread TA
"Andy Dustman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > This is untrue: cursor.scroll() is an optional DB-API 2.0 extension. > > http://www.python.org/peps/pep-0249.html > > MySQLdb supports this, but I do not know about your case. Yes 'cursor.scroll()' is optional and pyS

Re: Cursor navigation

2005-07-19 Thread Andy Dustman
TA wrote: > Hi, > > This might be a silly question, but I was wondering how you would navigate > backwards in a PostgreSQL cursor when the Python DB-API 2.0 allows records > to be fetched in a forward-only manner? This is untrue: cursor.scroll() is an optional DB-API 2.0 extension. http://www.pyt

Cursor navigation

2005-07-18 Thread TA
Hi, This might be a silly question, but I was wondering how you would navigate backwards in a PostgreSQL cursor when the Python DB-API 2.0 allows records to be fetched in a forward-only manner? I have tried different solutions - two of which are included here. The first solution uses the cursor d