I am also facing a similar problem. I have created associations in
Past successfully. But sometimes even though everything looks correct
but we see no sign of association.
I want to ask Is there any way of checking where we are going wrong?
On Jan 30, 9:46 am, Mac65 <[EMAIL PROTECTED]> wrote:
> This is using 1.2.0.6311 beta
>
> I may be mistaken about how this should work, but I thought setting
> the belongsTo variable in a model would cause it to join automatically
> when using the find ('all') method on that model.
>
> I have two models:
>
> class Collector extends AppModel
> {
> var $name = 'Collector';
> var $belongsTo = array('User' =>
> array('className' => 'User',
> 'fieldName' => 'User.first_name')
> );
>
> }
>
> class User extends AppModel
> {
> var $name = 'User';
> var $hasMany = array('Collector' =>
> array('className' => 'Collector')
> );
>
> }
>
> I'm trying to access the Collector model from my AppController class.
>
> It looks something like this:
>
> class AppController extends Controller {
> var $uses = array('Users', 'Collectors');
>
> function beforeFilter()
> {
> $collectors = $this->Collectors->find ('all', array (
> 'fields' => array ('id',
> 'name', 'User.first_name', 'User.last_name'),
> 'recursive' => 0)
> );
> }
>
> }
>
> The find does not join the records and I get a SQL error about unknown
> table 'User'.
>
> If I use bindModel and manually set the belongsTo information right
> before calling the find, then it works fine.
>
> It looks like my 'var $belongsTo' is not getting set in the collector
> model for some reason, but I can't figure out why.
>
> Thanks for any help.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
