I've written the validator like this: def create(): db.booking.room_id.requires = IS_IN_DB(db, db.room.id, '% (name)s',multiple=True) form = crud.create(db.booking, next = URL('index')) return dict(form=form)
and when I run it in the browser if I try to save the data I get a ticket, the traceback says: Traceback (most recent call last): File "gluon/restricted.py", line 188, in restricted File "C:/SERVER/web2py/applications/booksys/controllers/ bookings.py", line 28, in <module> File "gluon/globals.py", line 95, in <lambda> File "C:/SERVER/web2py/applications/booksys/controllers/ bookings.py", line 20, in create File "gluon/tools.py", line 2902, in create File "gluon/tools.py", line 2845, in update File "gluon/sqlhtml.py", line 1130, in accepts File "gluon/sqlhtml.py", line 36, in safe_int TypeError: int() argument must be a string or a number, not 'list'