I understand how to set the ordering for the bound models, but how can
I set restrictions and also give an order for the main model?
for instance, I want to select all members whose last names begin with
a particular letter, binding ther profiles, restricted to email &
phone. But I'd like the members ordered by last_name. Bindable's
restrict syntax has a way to order, but only for the bound models, not
the main one. And it seems to be somehow interfering with the $order
param given to find() (although, looking at the bindable.php source, I
can't figure out why).
$conditions = array(
'conditions' => "LOWER(SUBSTRING(last_name, 1, 1)) = '${letter}'",
'restrict' => array('MemberProfile(email, telephone)')
);
$order = 'Member.last_name ASC';
$this->set('members', $this->Member->find('all', $conditions, null,
$order));
This selects everything fine except there's no ORDER BY clause.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
