|
|
doctrine-user |
SQL queries
1. SELECT DISTINCT p2.id FROM producto p2 LEFT JOIN
2. SELECT p.id AS p__id, p.precio AS p__precio, p.descripcion AS
I use sfDoctrinePager exactly the same problem occurs
On 2 jul, 18:14, Szabolcs Heilig <szabolcs.hei...@gmail.com> wrote:
> To get closer tho know what does Doctrine in that case,
> echo $query->getSql();
> You can check the generated SQL with that step.
> 2009/7/2 Nixs <acron...@gmail.com>
> > hello. I'm in a weird situation. I need to paginate
> > here's the code:
> > public static function buscarProductos($tiendaId,$cantResultados =
> > $query= Doctrine_Query::create()
> > return $query;
imagenes_producto i2 ON p2.id = i2.producto_id LEFT JOIN categoria c2
ON p2.categoria_id = c2.id WHERE p2.tienda_id = 1 ORDER BY p2.id desc
LIMIT 4 OFFSET 13
p__descripcion, p.titulo AS p__titulo, p.moneda AS p__moneda, i.id AS
i__id, c.id AS c__id, c.nombre AS c__nombre FROM producto p LEFT JOIN
imagenes_producto i ON p.id = i.producto_id LEFT JOIN categoria c ON
p.categoria_id = c.id WHERE p.tienda_id = 1 ORDER BY p.id desc
> Hello,
> (your offset is out of the bound) check the generated SQL with:
> > 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!
> > 10,$offSet){
> > ->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);