Hello,
I need to paginate the following select.
select companies.name, purchase_orders.id, numero_orden_compra,
numero_contrato, codigo_producto, codigo_modelo, purchase_orders.created
from purchase_orders
join contracts on contracts.id = purchase_orders.contract_id
join companies on companies.id = contracts.company_id
where status_id = 10
order by
(select max(purchase_orders.created) from purchase_orders where
purchase_orders.contract_id = contracts.id and purchase_orders.status_id =
10),
codigo_producto,
purchase_orders.created
My problem is I don´t know how to paginate this.
Please help me.
Regards
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
