I'm using 1.2.x (latest SVN from trunk) fyi. Anyways I've set up a notes system to keep track of my notes internally, which is scaling to be quite efficient for what I need / what. Now here is my dilema. I have three tables:
notes id title body created user_id users id username password followups id comment user_id note_id created I believe I'm following the Cake style table layout and structure because most of my relations work. The followups table is supposed to like comments on the note. Anyways when I'm viewing a note that has follow ups it appears below the note's properties and says Related Followups and it's a list of all the connected followups to that note. Now the thing is here is what it looks like (from scaffolding) |Comment| ----------------------------------- | User | Note | Action | |This is doable, don't worry | 1 | 1 | View, Edit, Delete | The problem is, I can't seem to change that 1 to the actual username and I'm not sure how without writing a custom sql query to handle the entire fetching of the followups to notes relationship. Can someone please help me out? Here's my cake relationship layout model user User hasMany Note User hasMany Followup model followup Followup belongsTo Note Followup belongsTo User model note Note belongsTo User Note hasMany Followup I'm not asking for someone to completely write my script just to lend a helping hand as to if it's doable with the cake relations or do I have to custom query this certain thign I want. thanks for your time appreciate any response i get. --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
