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

Reply via email to