Re: Reverse relations?

2009-01-01 Thread WebbedIT
Not that it always makes logical sense, but in this case I do agree that a user or person belongs to their country as they are an inhabitant of that country. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP

Reverse relations?

2008-12-31 Thread gearvOsh
I know how to do relations for foreign keys, but I cannot figure out how to do this. In my users table, I have a column called state_id and country_id. I tried a hasOne country but that does not work. It looks for a user_id on the Country table that matches the user id, I need it the other way

Re: Reverse relations?

2008-12-31 Thread Bernardo Vieira
User belongsTo Country? gearvOsh wrote: I know how to do relations for foreign keys, but I cannot figure out how to do this. In my users table, I have a column called state_id and country_id. I tried a hasOne country but that does not work. It looks for a user_id on the Country table that

Re: Reverse relations?

2008-12-31 Thread WebbedIT
User belongsTo Country? Yip .. the rule of thumb is that the table containing the foreign key belongsTo the other table. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send

Re: Reverse relations?

2008-12-31 Thread gearvOsh
I could of sworn I tried that and it didn't work, I must have changed the foreign_key. Anyways that worked. Yeah I was also thinking in my system... is that a user is top level and he has many different parts. A user is not necessarily part of a country, but I guess ill have to do it that way.

Re: Unbind Reverse Relations in Recursive Queries

2008-03-03 Thread sabkaraja
cool. its working :) Does it support conditions from related models? eg: I want to load the chapters for a specific user only? $subjects = $this-Subject-find('all', array('conditions'='Subject.enabled=1', 'restrict'=array(

Unbind Reverse Relations in Recursive Queries

2008-03-02 Thread sabkaraja
Hi I have 3 models: Subject, Topic Chapter Subject hasMany Topics Topic belongsTo Subject Topic hasMany Chapters Chapter belongsTo Topic User HABTM Chapter I am trying to do a recursive query ($this-Subject- findAll('Subject.enabled=1'); ) to find out all the subjects topics

RE: Unbind Reverse Relations in Recursive Queries

2008-03-02 Thread websta*
, 3 March 2008 8:38 p.m. To: Cake PHP Subject: Unbind Reverse Relations in Recursive Queries Hi I have 3 models: Subject, Topic Chapter Subject hasMany Topics Topic belongsTo Subject Topic hasMany Chapters Chapter belongsTo Topic User HABTM Chapter I am trying to do a recursive query

Re: Unbind Reverse Relations in Recursive Queries

2008-03-02 Thread Matias Lespiau
On Mon, Mar 3, 2008 at 5:38 AM, sabkaraja [EMAIL PROTECTED] wrote: Hi Hi, I have 3 models: Subject, Topic Chapter Subject hasMany Topics Topic belongsTo Subject Topic hasMany Chapters Chapter belongsTo Topic User HABTM Chapter I am trying to do a recursive query