Question about findAll and limits

2008-06-30 Thread Margarittka
Hello! Does anybody know, how can i realize mysql-request like SELECT * FROM products WHERE Product.active = 1 LIMITS 30, 5; ? i want to know how to do such request with two limits using function findAll. Please, help me if you know how to do it!! Thank for any help

Re: Question about findAll and limits

2008-06-30 Thread Jonathan Snook
When using two numbers, the first number defines the OFFSET, the second number is the LIMIT. In a findAll query, look to the PAGE parameter: findAll(string $conditions, array $fields, string $order, int $limit, int $page, int $recursive); The page will automatically set the offset to $page *