I don't want the number of the reference (that it shows) I want the 'string'
tht is associated to it!
Not the cliente_id: ex: 1, 2, 3, 4....
But the name of the cliente in cliente.name field!
Carlos Aboim
2009/8/17 mdipierro <mdipie...@cs.depaul.edu>
>
> I do not see anything wrong in it. If in the view you have something
> like
>
> {{=row.cliente}} that gives you the id you may want to try replace it
> with
>
> {{=registos.obra.cliente.represent(row.cliente)}}
>
> On Aug 17, 9:39 am, Carlos Aboim <abo...@gmail.com> wrote:
> > Yah I am sorry... my nervous mind!
> > On saying "didn't worked" I meant there was no change.
> > On rendering I get the page with exactlly the same reference to the
> 'name'
> > field of database 'cliente' which is a reference to de 'cliente_id'. But
> I
> > wnat the string in it!!
> >
> > thank you and apologize for the mess
> >
> > Carlos Aboim
> >
> > 2009/8/17 mdipierro <mdipie...@cs.depaul.edu>
> >
> >
> >
> > > This correct. Can you explain better what you mean by "it did not
> > > work". Which is the controller that does not work. What is the view.
> > > What do you get instead?
> >
> > > On Aug 17, 3:32 am, Carlos Aboim <abo...@gmail.com> wrote:
> > > > Hi,
> > > > Didn't worked, maybe I missing something or do some error!
> >
> > > > this is my real model, with te last line added as suggested is it
> > > correct?
> >
> > > > thank you
> > > > Carlos Aboim
> >
> > > > # coding: utf8
> >
> > > > import datetime
> >
> > > > now = datetime.datetime.now()
> >
> > > > registos=SQLDB("sqlite://registos.db")
> >
> > > > registos.define_table('cliente',
> > > > SQLField('nome', 'string'),
> > > > SQLField('contacto', 'string'),
> > > > SQLField('email'),
> > > > SQLField('morada', 'string', length=100))
> >
> > > > registos.define_table('obra',
> > > > SQLField('numero', 'integer'),
> > > > SQLField('nome', 'string'),
> > > > SQLField('descricao', 'text', label='Descrição'),
> > > > SQLField('quantidade', 'integer'),
> > > > SQLField('cliente', registos.cliente),
> > > > SQLField('vendedor', default='Rujoca'),
> > > > SQLField('entrada', 'date', default=now),
> > > > SQLField('entrega', 'date'),
> > > > SQLField('preview', 'upload',))
> >
> > > > registos.cliente.email.requires = IS_NULL_OR(IS_EMAIL())
> >
> > > > registos.obra.numero.requires = [IS_INT_IN_RANGE(5000,
> > > > 50000),IS_NOT_IN_DB(registos, 'obra.numero'), IS_NOT_EMPTY()]
> > > > registos.obra.nome.requires = IS_NOT_EMPTY()
> > > > registos.obra.descricao.requires = IS_NOT_EMPTY()
> > > > registos.obra.cliente.requires = IS_IN_DB(registos,
> registos.cliente.id,
> > > > registos.cliente.nome)
> > > > registos.obra.vendedor.requires = IS_IN_SET(['João Luís', 'Luís
> Bilro',
> > > > 'Luís Pereira', 'Paulo Gonçalves', 'Vítor Silva', 'Rujoca', 'Dacor'])
> > > > registos.obra.entrega.requires = IS_NOT_EMPTY()
> > > > registos.obra.preview.comment = 'Utilize ficheiros em formato .jpeg
> de
> > > > preferência'
> > > > registos.obra.cliente.represent = lambda cliente:
> > > > registos.cliente[cliente].nome
> >
> > > > 2009/8/14 mdipierro <mdipie...@cs.depaul.edu>
> >
> > > > > db.dogs.owner_id.represent=lambda owner_id: db.users[owner_id].name
> >
> > > > > On Aug 14, 9:59 am, Carlos Aboim <abo...@gmail.com> wrote:
> > > > > > Hi folks!
> > > > > > I am here again as promised. (just kidding)
> >
> > > > > > I whould like to know how to access a cross reference model name.
> > > > > > For example to clarify,
> > > > > > I got:
> >
> > > > > > db.define_table('users',
> > > > > > Field('name'),
> > > > > > Field('email'))
> >
> > > > > > # ONE (users) TO MANY (dogs)
> > > > > > db.define_table('dogs',
> > > > > > Field('owner_id',db.users),
> > > > > > Field('name'),
> > > > > > Field('type'),
> > > > > > Field('vaccinated','boolean',default=False),
> > > > > > Field('picture','upload',default=''))
> >
> > > > > > And I want to render the 'owner' field of the 'dogs' table with
> the
> > > > > > 'name' from 'users' table
> > > > > > or better dogs.owner = users.name
> >
> > > > > > I'm just getting the _id of that field (integer)
> >
> > > > > > Can I do this??
> >
> > > > > > Thank you
> > > > > > Carlos Aboim
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
