[Solar-talk] limit in select
Jeff Surgeson
solar at 3hex.com
Wed Jul 26 08:10:59 PDT 2006
Hi Rodrigo
> > There is a limit() function in Solar_Sql_Select, but how do I use it in
> > conjunction with a select or fetchAll call?
> >
> > $this->list = $this->bd_news->fetchAll($where, $order,
> > $page)->limit($limit) ?
>
> I guess $bd_news extends Sql_Table? If yes, I think you only need to
> set a limit for it before fetchAll():
Correct
> $this->bd_news->setPaging($limit);
Yes but that is to set the number of rows displayed per page, not so? I want
to limit the total number of rows returned by using ->limit()
--
Jeff Surgeson
More information about the solar-talk
mailing list