I have the following table:
Model
db.define_table('queries',
Field('my_db', 'string', required=True),
Field('title', 'text', required=True),
Field('query', 'text', required=True),
Field('modified_by', 'string', required=True,
writable=False,
readable=True),
Field('modified_date', 'datetime',
update=request.now,
writable=False, readable=True),
Field('creation_date', 'datetime',
default=request.now,
writable=False, readable=True),
Field('enabled', 'boolean', default=True),
Field('dependence', 'integer', default=1),
Field('info_needed', 'string', default=None),
migrate=True)
Controller
def edit_query:
record = db.queries(db.queries.id==query_id)
form=SQLFORM(db.queries, record)
if form.accepts(request.vars, session):
redirect(URL('default','queries'))
response.flash = 'query updated'
elif form.errors:
response.flash = 'form has errors'
return dict(form=form)
When I edit an existing queries row, modified_date does not get
updated with the current datetime.datetime.now (or anything for that
matter). Any ideas?
Jim