Hello,
I am having a strange behavior using pagination with Cake 1.2.3.8166 and
Cake 1.2.4.8284
I defined the $paginate variable in the controller as:
var $paginate = array(
'PurchaseOrder' => array(
'limit' => 20,
'conditions' => array('PurchaseOrder.status_id' => 14),
'contain' => array(
'Contract',
'Equipment' => array(
'fields' => array('id', 'status', 'numero_serie'),
'conditions' => array('Equipment.status' => 1)
)
),
'order' => array(
'Contract.created' => 'ASC',
'PurchaseOrder.id' => 'ASC'
)
)
);
Of course PurchaseOrders belongsTo Contract, and PurchaseOrdes hasMany
Equipment, the problem is, in index method:
$orders = $this->paginate('PurchaseOrder');
The problem s that in $orderd array the Equipment is shifted one record
ahead of the PurchaseOrder that corresponds to, so the Equipment for record
[0] is null, then the Equipment in record [1] is the one should be in record
[0] and so on, the last Equipment is missing. Because business rules, every
PurchaseOrder with status_id 14 has one and only one Equipment with status =
1.
If I check the database with SELECT statements, in there all is OK.
Am I doing something grong?, Please help.
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
-~----------~----~----~----~------~----~------~--~---
