executing no realtionship tables

2009-07-30 Thread abhishekh
Hi, I have some static tables in my database. they have no relationship with any other tables. That table store read only data. How do I fetch data from that table, without writing any custom query, from any model.? -- View this message in context:

HABTM query issue

2009-07-21 Thread abhishekh
profiles has many users. users has many profiles. I just want to do a query which will join profiles profiles_users table, so i do the following: $this-Profile-Behaviors-attach('Containable'); $this-Profile-contain(ProfilesUser); $this-data = $this-Profile-find('all'); However, its not

Re: Many to Many relationship issue

2009-07-15 Thread abhishekh
Thanks for the input. But,the relationship is this way 1) users HASBTM profiles. 1st scenario ) user can have multiple profiles. A profile can belong to multiple user. 2nd scenrio ) even if user is not having a particular profile, he can still follow that profile. thats the reason there are

Many to Many relationship issue

2009-07-14 Thread abhishekh
Hi, I have a quick question about Many to Many relationship works in cakephp. I have two priamry tables. 1)users 2)profiles. There is Many to Many relationship between these tables i.e profiles_users table. Till here its fine. Now, here is a new thing... I have one more Many to Many

2 many to many relationship between tables

2009-07-13 Thread abhishekh
Hi, I have a quick question about Many to Many relationship works in cakephp. I have two priamry tables. 1)users 2)profiles. There is Many to Many relationship between these tables i.e profiles_users table. Till here its fine. Now, here is a new thing... I have one more Many to Many