If I undestood wll your need, it should be enough to define 'username'
as displayField for the user model:

model user
var $displayField = 'username';
User hasMany Note
User hasMany Followup

On 24 Set, 16:44, jwerd <[EMAIL PROTECTED]> wrote:
> 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 cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to