Hello there,
I've got a simple construction of two models: users and familymembers;
every user belongs to a familymember and a familymember has one user.
So the database looks like this:
`familymembers` (
`id` int(11) auto_increment,
`firstname` varchar(20),
`lastname` varchar(100),
`gender` tinyint(4),
`dob` date,
`email` varchar(100),
`created` datetime,
`deleted` tinyint(1)
);
`users` (
`id` int(11) auto_increment,
`familymember_id` int(11),
`username` varchar(20),
`password` varchar(255),
`deleted` tinyint(1),
`created` datetime
);
I'm using a hasOne association in the Familymember model, so it will
only return one record ... great! But now I want to be able to keep
old records, so if a user would be removed Users.deleted will be set
to 1. Also great, so I thought, just fix the association so it will
only return records where Users.deleted = 0. So I did that like this:
var $hasOne = array(
'User' =>
array(
'className' => 'User',
'conditions' => 'User.deleted = 0'
)
);
The CakePHP Manual says the following about hasOne associations:
"We could use this to tell Cake to only associate a Profile that has a
green header, if we wished. To define conditions like this, you'd
specify a SQL conditions fragment as the value for this key:
"Profile.header_color = 'green'"." -http://manual.cakephp.org/
chapter/models
So in my case this model should only associate a Familymember that has
not been deleted. But this simply doesn't work, Cake ignores the
'conditions'-part alltogether. I even tried to make conditions that
would generate errors ... didn't get an error and none of the
'conditions' are included in the SQL-query.
I've googled around to see if anyone else has a similar problem or
similar system explained but haven't had any luck so far. So is there
anyone who can tell me what I'm doing wrong, or even better, tell me
how to do this the right way.
Thanks!
By the way: I'm using PHP 4.4 and CakePHP 1.1.14.4797
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
