reading in a row from a table one row at a time
Posted on 2004-11-12
I need to read in a row from a table, one row at a time. so lets say i have 10 rows, i need to be able to read in just one row at a time from one to ten, and sleep every time after it reads in a row if a certain condition is met.
currently i have
rs = stmt.execute("select * from table_name)
but this isnt what i want to do obviouslly. i want to read in one row, then do something then check if tablename2 has something in it, if so then sleep for a period of time, then run again and read in the next row and do the same check as before. and so on and so forth.
read in row
read in another row
the api doesnt appear to have anything to read in a row at a time and to make note of every row that has been read in and every row that has to be read in yet.
thanks in advance