Hello bakers, I have a table linking two other tables. To stay in phpcake examples parlance it looks like this: (my situation is different, i'm just trying to keep it simple & short enough to post)
CREATE TABLE posts_authors ( type INTEGER DEFAULT 0, post_id INTEGER REFERENCES posts(id) ON DELETE CASCADE, author_id INTEGER REFERENCES authors(id) ON DELETE CASCADE, PRIMARY KEY(post_id, author_id, type) ); The 'type' column refers to the type of relationship between post & author. For instance the same author can be a moderator but also post as 'common user'. (again it's somewhat different in my case, but this comes close :) When in the controller, i issue a read() or find*(), with $recursive I do get the post & author but the type column is left out. I can see it isn't included in the sql statements either. Is there a simple way to include type as well ? something with 'fields' or such ? TIA, Albert --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
