Message inserted but id is blank
On Mon, 20 Aug 2018, 15:45 Anthony <abasta...@gmail.com> wrote:
> 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.
>
--
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.
