I want to upload a file and store it in a blob field: db.define_table( "data", Field("citation", "string", required=True, notnull=True), Field("datafile", "upload", uploadfield="data"), Field("data", "blob"), )
But if I insert a record (through SQLFORM or admin) but leave the datafile field empty, i.e., I input a citation but not a file, I get this error: web2py Version 1.88.2 (2010-10-29 23:04:43) Traceback (most recent call last): File "/home/rree/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/rree/web2py/applications/mytest/controllers/ appadmin.py", line 410, in <module> File "/home/rree/web2py/gluon/globals.py", line 96, in <lambda> self._caller = lambda f: f() File "/home/rree/web2py/applications/mytest/controllers/ appadmin.py", line 125, in insert if form.accepts(request.vars, session): File "/home/rree/web2py/gluon/sqlhtml.py", line 1105, in accepts value = fields[fieldname] KeyError: 'data' How to make the upload field optional? Thanks -Rick