Is the problem that you are not getting the id of the latest insert, or that you are getting the correct record, but no message is being inserted?
Also, no reason to use if/else in the controller if you are simply going to call "pass" in each case. Just call SQLFORM(...).accepts(), or better yet, SQLFORM.process(). Anthony On Monday, August 20, 2018 at 8:27:11 AM UTC-4, lbjc1...@gmail.com wrote: > > I am using javascript to insert to database and it works well with > <script> > jQuery('#myform').submit(function() { > ajax('{{=URL('my_search_party')}}', > ['message'], 'target'); > return false; > }); > </script> > > Controller code: > def my_search_party(): > form = SQLFORM(db.post) > if form.accepts(request, formname=None): > pass > elif form.errors: > pass > > But when i try to access the recent posted text with this code it does not > appear, instead its a blank message > row = db(db.post.author== auth.user.id).select(db.post.id, orderby=~db. > post.id, limitby=(0,1)).first() > id = row.id > > -- 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.