[web2py] Re: Displaying Foreign Key

2010-03-23 Thread mdipierro
No joins on gae. On Mar 23, 6:12 pm, Al wrote: > Would this work in GAE which does not handle table join? or the DAL > automatically handle this for you? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web.

[web2py] Re: Displaying Foreign Key

2010-03-23 Thread Al
Would this work in GAE which does not handle table join? or the DAL automatically handle this for you? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group,

[web2py] Re: Displaying Foreign Key

2010-03-23 Thread Greg
Ah, very simple. Thanks, guys. P.S. It's a good thing web2py makes it easy to rename tables. :) On Mar 22, 6:07 pm, mdipierro wrote: > You can just replace > > {{=event.room_id}} > > with > > {{=event.room_id.name}} > > This will result in one extra select per record. > > You can also use a joi

[web2py] Re: Displaying Foreign Key

2010-03-22 Thread mdipierro
You can just replace {{=event.room_id}} with {{=event.room_id.name}} This will result in one extra select per record. You can also use a join #default.py def index(): events = db(db.events.room_id==db.rooms.id).select(orderby=db.events.event_date) return dict(events=events) #index.ht

[web2py] Re: Displaying Foreign Key

2010-03-22 Thread mr.freeze
It's as simple as this: {{=event.room_id.name}} On Mar 22, 5:45 pm, Greg wrote: > Hello! > > I have a view that lists some records (events), one of the fields > (events.room_id) is a foreign key. When i display these records I want > to display rooms.name, not events.room_id. Can someone give me