This all looks promising. Meanwhile, here's my model with irrelevant Fields
omitted and below that my query for the Select. Thanks for the help!
A simplified version of my model:
db.define_table('movie',
Field('title','string'),
db.define_table('person',
Field('name', 'string', unique=True),
db.define_table('star',
Field('movie_id', db.movie),
Field('person_id', db.person),
movies_and_stars = db((db.movie.id == db.star.movie_id) &
(db.star.person_id == db.person.id))
On Tuesday, August 14, 2012 2:16:56 AM UTC-4, rochacbruno wrote:
>
> I guess you can also do:
>
> table = TABLE(*[TR(TD(movie.title), TD(UL(*[LI(star.name) for star in *
> movie.stars.select()*])) for movie in movies])
>
> when a table is referenced by another, he gets a "DAL Set" object with the
> referer name.
>
> movie.*stars *will be a DAL Set. which has *select, update, delete*methods
>
> But it will only happens depending on your model and relations definition.
>
> Can you share your model for those 2 tables?
>
>
> On Tue, Aug 14, 2012 at 3:10 AM, Bruno Rocha <[email protected]<javascript:>
> > wrote:
>
>> Foreach movie in movies
>> print movie.title
>> foreach stars in movie.stars
>> print star.name
>>
>
>
--
