record = db(db.loc_data.school_id == auth.user_id).select().last() record.update_record(end_time=request.utcnow+datetime.timedelta(0,19800))
or, REALLY better (for anyone listening, using first() and last() without a limitby and orderby is the FIRST thing to change in your app's code, performance-wise) record = db(db.loc_data.school_id == auth.user_id).select(limitby=(0,1), orderby=~db.loc_data.id).first() record.update_record(end_time=request.utcnow+datetime.timedelta(0,19800)) On Wednesday, May 11, 2016 at 6:03:51 PM UTC+2, Steve Joe wrote: > > Thank you for pointing that out Niphlod. So how should I correct it? > > On Wednesday, May 11, 2016 at 5:37:43 PM UTC+5:30, Niphlod wrote: >> >> yep. you need to FILTER before APPLYing the update. it's rather easy to >> spot the error because last() comes AFTER update(). >> >> On Wednesday, May 11, 2016 at 1:15:45 PM UTC+2, Steve Joe wrote: >>> >>> db(db.loc_data.school_id == >>> auth.user_id).update(end_time=request.utcnow+datetime.timedelta(0,19800) >>> ).last() >>> >>> this doesn't tend to work. >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.