> -----Original Message-----
> From: Ann W. Harrison [mailto:aharrison@...]
> Sent: Thursday, May 31, 2001 6:35 PM
>
> At 12:12 PM 5/31/2001 -0400, Ann W. Harrison wrote:
>
> >The problem I have with the syntax SELECT .... LIMIT (11, 20)
> >...
> >If this were done as a single select, it would read 120 records.
> >If it were done as individual limited selects, it would read
> >over 6000 records. I suppose that doesn't matter.
>
> Of course, SELECT ... LIMIT (111, 120) is reasonably good
> you really want just the hundred and eleventh to the hundred
> and twentieth records and don't care about 1-111. Is that
> likely?

YES, with web applications at least.
I described that in my post.

Thanks,
Paulo Gaspar

> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.