Robert P kindly solved a problem I was having with updating records in
a HABTM relationship so many thanks to him for that!
I'm now trying to query the data but have added an additional model to
my system, Regions. So it looks something like:
Members HasAndBelongsToMany County
County BelongsTo Region (and Region hasMany County)
I'm trying to return members that belong to Region.id = 1 and am using
this to do so:
$members = $this->Member->County->Region->find('all', array
('conditions' => array('Region.id' => $id), 'recursive' => 2));
This does return all members belonging to Region 1 but it also returns
a whole lot of other information with it. Is there any way I can
construct a query that literally just returns the corresponding
members?
The above returns the following data: http://bin.cakephp.org/saved/48057
which includes County and Region data and in this instance, I don't
need it. I'll live with it if I need to but I'd rather I didn't have
to! Removing 'recursive' => 2 results in just the Region and County
data being returned.
Many thanks,
Alastair
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
