access id of newly inserted text

[lbjc...@gmail.com]

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

[Anthony]

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

[Lovedie JC]

Message inserted but id is blank 

--
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+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Anthony]

On Monday, August 20, 2018 at 8:47:17 AM UTC-4, Lovedie JC wrote:

Message inserted but id is blank 

It's not possible for the id to be blank. Are you saying:

id = row.id

throws an exception? How are you determining that "id is blank"?

Anthony

[Lovedie JC]

Actually, I just discovered the problem. 

I wasn't posting to the correct DIV in html, hence appearing as a blank message. 

I tried to render it into view.html and saw the error.

Now my next challenge is to fix it into the bubble.

See attached.

--