I have a field that I want validated in an SQLFORM, but I don't want a dropbox. The book directs us to use brackets as follows:
If you want the field validated, but you do not want a dropbox, you must put the validator in a list. db.dog.owner.requires = [IS_IN_DB(db, 'person.id', ')] I also want the field to be able to be null. The book directs us to use IS_NULL_OR as follows: Sometimes you need to allow empty values on a field along with other requirements. For example a field may be a date but it can also be empty. The IS_NULL_OR validator allows this: requires = IS_NULL_OR(IS_DATE()) So, I attempted to combine the two: db.dog.owner.requires = IS_NULL_OR([IS_IN_DB(db, 'person.id', ')]) But, this results in an error (traceback info below). If I don't include the brackets, the form works fine (except it populates a dropbox as one would expect). Is this an error on my part, a restriction that needs to be documented, or an error in web2py? =========================================== S'Traceback (most recent call last):\n File "gluon/restricted.py", line 173, in restricted\n File "w:\\web2py_win\\applications\ \canyonezt/controllers/default.py", line 166, in <module>\n File "gluon/globals.py", line 96, in <lambda>\n File "gluon/tools.py", line 1851, in f\n File "w:\\web2py_win\\applications\\canyonezt/ controllers/default.py", line 127, in profile\n File "gluon/ sqlhtml.py", line 839, in accepts\n File "gluon/html.py", line 1311, in accepts\n File "gluon/html.py", line 452, in _traverse\n File "gluon/html.py", line 452, in _traverse\n File "gluon/html.py", line 452, in _traverse\n File "gluon/html.py", line 452, in _traverse\n File "gluon/html.py", line 459, in _traverse\n File "gluon/html.py", line 1118, in _validate\n File "gluon/validators.py", line 2210, in __call__\nTypeError: \'list\' object is not callable\n' -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@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.
