That's not going to work. In fact, if you figured out a way to get Cake to make it work, I'd file a ticket to say that it was a bug, not a feature.
A "join table" should have only fields which are foreign keys to other tables. Its sole purpose is to join records between 2 or more tables, nothing else. In your case, i think you should put login & password in the members table. And members_role should have only member_id and role_id columns. HOWEVER, if your members can only ever have a single role, you can save yourself some trouble by adding a role_id column to members and get rid of the join table. On Fri, Jun 6, 2008 at 8:05 AM, dealbest <[EMAIL PROTECTED]> wrote: > > I have 3 tables... On of them is a joint table... > > Member, MemberRole, Role :) > > Member= Member_id, name, address... > > MemberRole= Member_id, Role_id, password, login... > > Role= Role Id, Type.... > > This is a typical relationship... > > My relationship works find and I can assign a role to each member... > > I'm using stable cake.... > > I need to know to add extra data to join table ... > > My join table (MemberRole) contains extra fields Password and > Login ... > > How to add data to the extra fields in join table while adding a > Member.... (P.S When I add a new member, a new MemberRole record is > generated, but the extra fields remains empty) > > I really need your help now.... > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
