Problem with paged Doctrine in using Doctrine Query -> offset to the query page - doctrine-user

Message from discussion Problem with paged Doctrine in using Doctrine Query -> offset to the query page

Nixs

More options 2 July, 21:58

From: Nixs <acron...@gmail.com>

Date: Thu, 2 Jul 2009 13:58:23 -0700 (PDT)

Local: Thurs 2 July 2009 21:58

Subject: Problem with paged Doctrine in using Doctrine Query -> offset to the query page

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

hello. I'm in a weird situation. I need to paginate
and show 10 results per query does pagina.mi correctly.
Then -> offset (10) in the query shows the following 10
results.
The question is what does it correctly. The problem is that when
asks a page, for example the number 500, which is not logically
There, instead of not returning anything, I devulve ALL!

here's the code:

public static function buscarProductos($tiendaId,$cantResultados =
10,$offSet){

$query= Doctrine_Query::create()
->select
('p.id,ip.id,p.precio,p.descripcion,p.titulo,p.moneda,c.id,c.nombre')
->from('Producto p,p.ImagenesProducto ip,p.Categoria
c')
->addWhere('p.tienda_id='.$tiendaId)
->orderBy('p.id desc')
->limit($cantResultados)
->offSet($offSet)
->execute(array(),Doctrine::HYDRATE_ARRAY);

return $query;

Any idea? now, thanks

Reply to author Forward