On Jul 8, 12:43 pm, Robert P wrote:
> Refactored to remove unnecessary table.
>
> $joins = array(
> array(
> 'table' => 'counties_users',
> 'alias' => 'CountiesUsers',
> 'type' => 'INNER',
> 'conditions' => array('Member.us
Refactored to remove unnecessary table.
$joins = array(
array(
'table' => 'counties_users',
'alias' => 'CountiesUsers',
'type' => 'INNER',
'conditions' => array('Member.user_id =
CountiesUsers.user_id')
),
arr
Ah yes, I did mean AppModel. Either that or my local copy of Cake is
based on CVM. I can't seem to get ContainableBehaviour to work either.
It keeps trying to query the database using "contain" instead of SQL.
Time to fall back to a custom join perhaps?
$joins = array(
array(
Hi Robert,
Thanks for your help with this although it doesn't appear to be quite
working. It's certainly returning just members however it is returning
ALL members.
I'm assuming when you said AppController you meant AppModel for the
actsAs('Containable')?
The code I'm using is as follows:
App
That sould have been:
$this->Member->contain(array(
'County' => array(
'Region' => array(
'conditions' => array('Region.id' => $id)
)
)
));
$members = $this->Member->find('all');
On Jul 8, 12:58 pm, Robert P wrote:
Matt Curry does a good job of providing a default model setup for any
new application. If AppController doesn't already exist, create /app/
app_controller.php and add the following class, or copy the attributes
into your current one:
class AppController extends Controller {
var $actsA
Use "contain"
There is a chapter in the cookbook how to get only the records from related
models and not pull all the un-necessary info.
Dave
-Original Message-
From: Alastair [mailto:m...@alastairmoore.com]
Sent: July-07-09 10:31 PM
To: CakePHP
Subject: More HABTM questions - query