On Aug 6, 2007, at 4:49 PM, Ruud Gâst wrote:
> > No-one has an answer? I'd say a lot of people use the same > construction so it won't be that hard ... I just don't know how. What happens when you turn DEBUG up to 2 or so? Does the SQL include the condition? Have you tried clearing the model caches found in app/tmp/cache ? -- John > > On Aug 6, 3:01 am, Ruud Gâst <[EMAIL PROTECTED]> wrote: >> 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 -~----------~----~----~----~------~----~------~--~---
