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

Reply via email to