Hi all,
I'm a little confused about something I'm seeing with belongsTo
conditions, and from searching the docs and this list I haven't been
able to find an answer. Maybe some kind soul can help clear my
confusion?
In my Crop model I have:
var $belongsTo = array(
'EntryClassification' => array('className' => 'Classification',
'foreignKey' =>
'entry_classification_id',
'conditions' =>
array('EntryClassification.entry' => 1),
'fields' => '',
'order' => ''
)
);
When I do an find operation on a Crop and let it pick up associated
models I see that the condition is used, a fragment from the where
clause displayed in the debugger would be like:
LEFT JOIN `classifications` AS `EntryClassification` ON
(`Crop`.`entry_classification_id` = `EntryClassification`.`id` AND
`EntryClassification`.`entry` = 1)
However, in my crops_controller I do for a select box:
$entryClassifications = $this->Crop->EntryClassification-
>find('list');
and it brings back all classifications, not just those that meet the
"EntryClassification = 1" condition.
This is confirmed in the debugger, I see:
SELECT `EntryClassification`.`id`, `EntryClassification`.`name` FROM
`classifications` AS `EntryClassification` WHERE 1 = 1
Why is that? Shouldn't a find through the Crop->EntryClassification
association use the condition?
Thanks for any help in clearing my confusion!
Ian
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
