I need to be able to retrieve data from a database 1 to 50 records at a time. I want to retrieve for example 50 records from a database. Later I want to retrieve the next 50 records from the database that match the sql string for the first 50 etc...

does anyone have any ideas? If this isn't clear let me know and I'll try to clarify what I want here....