>>> db.define_table('me',Field('mom','reference me'),Field('name'))
>>> me=db.me.insert(name='Kim')
>>> me.mom=me
>>> print me.mom.mom.mom.mom.mom.name
Kim
On May 20, 1:14 pm, Yanni <apoe...@gmail.com> wrote:
> Yes that worked. Kinda weird :)
>
> pet.category.category_name worked.
>
> Thank you very much.
>
> Yanni.
>
> On May 20, 11:06 am, "mr.freeze" <nat...@freezable.com> wrote:
>
> > It will do it automatically. You should be able to do:
> > pet.category.name
>
> > On May 20, 12:58 pm, Yanni <apoe...@gmail.com> wrote:
>
> > > I'm slightly confused as to how to reference a field when I have the
> > > foreign key.
>
> > > table pets:
> > > pets.id
> > > name
> > > category (foreign key category.id)
> > > description
>
> > > table category:
> > > category.id
> > > category_name
>
> > > I am trying to show the category name, in my show page/function,
> > > instead of a number.
>
> > > In the controller, I do a
> > > show():
> > > id=request.vars.id
> > > pet=db(db.pets.id==id).select()
> > > return dict(pet=pet[0])
>
> > > In the view, among other things, I have {{=pet.category}}
> > > Which of course returns a number.
>
> > > At which point am I supposed to join the category table and the pet
> > > table, to do a lookup for the category name?
> > > What does the code for that look like? Does it have to be a join?
>
> > > Thank you very much.
> > > Yanni.
