Ok, I can't seem to solve this problem for the life of me. I have a
User model and a Zipcode model. Zipcode hasMany users. I want them to
join on User.zip = Zipcode.zip. I have to join on Zipcode.zip and not
Zipcode.id because a zipcode can have many rows because of several
city names, etc. I know this is not normalized, but it is much easier
like this. So I have a hasMany association that looks like this:
var $hasMany = array('User' =>
array('className' => 'User',
'conditions' => '',
'order' => '',
'dependent' => true,
'foreignKey' => '',
'finderQuery' => ' SELECT *
FROM users as User
JOIN zipcodes as Zipcode ON (User.zip = Zipcode.zip)'
)
);
I tried using the finderQuery after doing foreignKey => 'zip' didn't
work. I also had a belongsTo Zipcode in User with foreignKey =>
'zip' :
var $belongsTo = array('Zipcode' =>
array('className' => 'Zipcode',
'conditions' => '',
'order' => '',
'dependent' => true,
'foreignKey' =>
'zip'
)
);
With everything that I've tried, when I do a $this->Zipcode->User-
>findAll, or try to paginate with $this->Zipcode->User, it tries to
join on User.zip = Zipcode.id instead of Zipcode.zip.
Any help is much appreciated.
Jon
PS- I'm using Cake 1.2
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
