One way would be to make sure the rows are somehow numbered, or have a key field, which you should anyways for a good db design. You can then pass info use db specific options like MySQL limit, etc..., or just dynamically modify the where clause to not include the past ten, twenty records.
There are numerous ways of doing this. As Ronald said in a previous post, a search in the archives will turn our lots and lots of discussions of this issue. I can recall a lot of them in the past two years. Ilya -----Original Message----- From: Charles Day To: 'Michael Peppler'; Sterin, Ilya Cc: '[EMAIL PROTECTED] ' Sent: 11/29/01 2:29 PM Subject: RE: 1-10, 11-20 Precisely. We use SQL7/SQL 2000, and PostgreSQL 7. We can do this on the scripting side, but don't want to fetch all rows each time. -----Original Message----- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 4:18 PM To: Sterin, Ilya Cc: Charles Day; '[EMAIL PROTECTED] ' Subject: RE: 1-10, 11-20 I'm guessing the problem is getting the first 10 rows of a query, then rows 11-20, etc. How you do that depends on the database engine you use, and how the CGI script is implemented... Michael
