Zero option!! Or
Read this thread : http://groups.google.com/group/web2py/browse_thread/thread/974cb71a3eb297f6/fe9299eb54ad032a#fe9299eb54ad032a <http://groups.google.com/group/web2py/browse_thread/thread/974cb71a3eb297f6/fe9299eb54ad032a#fe9299eb54ad032a> Richard On Fri, Apr 8, 2011 at 3:51 AM, pbreit <[email protected]> wrote: > Should this work or is there some other equivalent? I want the field to be > optional but if filled in, unique in the DB. > > IS_EMPTY_OR(IS_NOT_IN_DB(db, 'person.name')) > > I got an error stack that I can't really understand and assume it's > related. > > Traceback (most recent call last): > File "gluon/restricted.py", line 188, in restricted > File > "/Users/pbreit/web2py/web2py.app/Contents/Resources/applications/init/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/init/controllers/default.py>, line > 88, in <module> > File "gluon/globals.py", line 124, in <lambda> > File > "/Users/pbreit/web2py/web2py.app/Contents/Resources/applications/init/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/init/controllers/default.py>, line > 70, in user > File "gluon/tools.py", line 1038, in __call__ > File "gluon/tools.py", line 1653, in register > File "gluon/sqlhtml.py", line 1031, in accepts > File "gluon/html.py", line 1720, in accepts > File "gluon/html.py", line 716, in _traverse > File "gluon/html.py", line 716, in _traverse > File "gluon/html.py", line 716, in _traverse > File "gluon/html.py", line 716, in _traverse > File "gluon/html.py", line 723, in _traverse > File "gluon/html.py", line 1493, in _validate > File "gluon/validators.py", line 2327, in __call__ > File "gluon/validators.py", line 2314, in urlify > AttributeError: 'NoneType' object has no attribute 'decode' > >
