in reply to More on selecting rows with DBI...

I think what you need is 'limit':

select fields from table where (something) limit 0,20;

That will only send the first 20 fields to the script. Then you can say "limit 20,40" for the next fields.

Replies are listed 'Best First'.
RE: Re: More on selecting rows with DBI...
by eduardo (Curate) on May 02, 2000 at 13:35 UTC
    I am afraid that you are mistaken. The syntax that you have just provided:
    	select <something> from <somewhere> limit n, x

	where n is 20 and x is 40
    will NOT give you rows 20 through 40... if you look at http://www.mysql.com/Manual_chapter/manual_Reference.html#SELECT in the mysql reference you will see that it states that the limit mechanism is:
    	limit offset, rows
    in order to receive rows 20 through 40 the proper limit syntax would have been:
    	limit 20, 20
    thank you.
[reply]

In Section Seekers of Perl Wisdom