in reply to View 100 then click for rest

To implement this you will need to use some sort of counting logic in your element printing logic. The following may not be actually functional, but can act as an starting point for your code. 
my $min=...  or 0;
my $max=$min+100;

my $row=0;
while(@r=$sth->fetchrow()){
  if(($row>=$min)&&($row<$max)){
    #print some data
  }
  $row++;
}
$sth->finish();

if($row>$max){
  # print next link w. "min=$max"
}

[download]

Replies are listed 'Best First'.
RE: Re: View 100 then click for rest
by le (Friar) on Jul 27, 2000 at 21:00 UTC
    Nice, but why return the full set, when you're only interested in some columns? 
    my $offset ||= 0;
my $max = 100;

my $sth = $dbh->prepare("SELECT ... LIMIT ?,?");
$sth->execute($offset, $limit);

    [download]
[reply]
[d/l]
      Not all databases support "LIMIT" as part of the SQL language. I agree that if your DB does support LIMIT then you should use it, but if you want a truly DB independant solution (much as DBI is database independant) you should avoid LIMIT and other not-widely supported extensions.
[reply]
        just out of curiosity... what database packages don't support limit?
[reply]

In Section Seekers of Perl Wisdom