forward and back in the table?

MySQL database connector for Python programming

Brought to you by: adustman

forward and back in the table?

Forum: Help

Creator: rafael massao

Created: 2009-09-10

Updated: 2012-09-19

rafael massao - 2009-09-10

Sorry my English!

Good morning!
I wonder how I can move forward and back a row in the table, I was able to move using the fetchone come back I'm not getting.
Sorry the question.
Thank all

massao

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- rafael massao - 2009-09-10
  
  Sorry, I forgot:
  
  Linux Python 2.6 using MySQLdb.cursors.Cursor
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Luis R. Rojas - 2009-09-12

You could try the scrool function in the cursor object.

cursor = db.cursor()

cursor.scroll(<POS>,mode='<MODE>')

where MODE is either relative or absolute, and POS is the row position.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

rafael massao - 2009-09-13

Hello, I had achieved using cursor.fetchall

cursor.fetchall row = ()

print row

print row

print row

Thanks anyway!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.