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
-~----------~----~----~----~------~----~------~--~---
