think carefully - do you want the DATABASE to hold TWO copies of the name
value in two tables? _Really_??
On Mon, Dec 29, 2008 at 4:20 PM, vince <lapcc...@gmail.com> wrote:
>
> thanks. it's my mistake that IS_IN_DB should not work this way.
>
> since i need the field holding the name instead of the id, i'll sort
> out other solution for it.
>
> -vince
>
> On Dec 30, 6:14 am, "Yarko Tymciurak" <yark...@gmail.com> wrote:
> > If what you want is a form which will list the names to choose from, then
> I
> > think what you want is something like this:
> > db.define_table('name_list',
> > db.Field('name')
> > )
> > db.define_table('members',
> > db.Field('name',db.name_list),
> > )
> > db.members.name.requires=IS_IN_DB(db,'name_list.id <
> http://name_list.name>',
> > '%(name)s')
> >
> > On Mon, Dec 29, 2008 at 4:08 PM, vince <lapcc...@gmail.com> wrote:
> >
> > > > this says the foreign key (a 'name_list.id') must be in the table
> > > name_list
> > > > in a string field, 'name'.
> >
> > > > This is why you get an error - you are checking a foreign key (an
> > > integer)
> > > > against a string.
> >
> > > oh so the case is IS_IN_DB allow referring via the key(id) ?
> >
> > > -vince
> >
> >
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
