Re: View 100 then click for rest

[lhoward]

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"
}

[le]

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);

[lhoward]

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.

[eduardo]

just out of curiosity... what database packages don't support limit?