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