I want to reference a project with a list of auth.users and get
'sqlite3.IntegrityError'> FOREIGN KEY constraint failed:
(self=<pydal.adapters.sqlite.SQLiteAdapter object>, table=<Table project
(id, name, project_member)>, fields=[(<pydal.objects.Field object>,
'Beratung'), (<pydal.objects.Field object>, ['4', '6'])])
db.define_table('project',
Field('name'),
Field('project_member','list:reference auth_user')
)
db.project.project_member.requires = IS_IN_DB(db,
'auth_user.id','%(first_name)s', db.auth_user._format, multiple=True)
What is wrong with my model definition?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.