On Thursday, August 16, 2018 at 1:53:18 AM UTC-7, Lovedie JC wrote:
>
> Sorry am trying to understand this statement: "If you're trying to look at
> the the row you just inserted, db.post.insert() returns the id of the new
> tuple, and that should allow your select() to be done by id."
> regards
>
I'm guessing that you want something like
def progress_view():
form = SQLFORM(Post, formstyle='table3cols').process()
if form.errors or "name" not in request.vars:
response.flash = "please enter a name"
return dict(form = form, name = "", r_id = None)
r_id = db.post.insert(name=request.vars.name)
row = db.post(r_id)
return dict(form = form, name = row.name, id = r_id)
I just noticed that you have Post in the SQLFORM() and post in the separate
insert. If these are both supposed to be Post (or both post), then you
don't need the separate insert, and the new row is
r_id = form.vars.id
You might want to review chapters 6 and 7 of the book, because I think
you've made things more complicated than they should be.
/dps
> On Thu, 16 Aug 2018 at 01:05, Dave S <snide...@gmail.com <javascript:>>
> wrote:
>
>>
>>
>> On Wednesday, August 15, 2018 at 8:12:37 AM UTC-7, lbjc...@gmail.com
>> wrote:
>>>
>>> Am puzzled by this, that I cant post text from request.vars value to
>>> database and when refreshing, the text is there but I cant access this
>>> value to controller functions.
>>> This is my code:
>>> def progress_view():
>>> form = SQLFORM(Post, formstyle='table3cols').process()
>>> if request.vars:
>>> r = [request.vars.name]
>>> codes.append(r[0])
>>> db.post.insert(name=codes[0])
>>> #db(db.post.id > 11).update(message=codes[0])
>>> row = db(db.post.author== auth.user.id).select(db.post.id,
>>> db.post.name, orderby=~db.post.id, limitby=(0,1)).first()
>>> code = row.name if row else None
>>> return dict(code=code)
>>> Is there a way of accessing the CURRENT value from request.vars to
>>> controller ? like append to a list without refreshing the page
>>> Is there a javascript/jquery function that can do DAL refresh?
>>>
>>
>> I think there may be some confusion, because you *are* accessing the
>> current value of request.vars.name in the controller,
>> which you put in a list and assign to r. Perhaps you want to show it in
>> the *view*, but you aren't returning anything but code to the view. code
>> is set to row.name, where you take the first tuple of the select()
>> results (which are in reverse order).
>>
>> If you're trying to look at the the row you just inserted,
>> db.post.insert() returns the id of the new tuple, and that should allow
>> your select() to be done by id.
>>
>> If I misunderstood what you're trying to do, try explaining again what
>> your workflow is and what you want to happen.
>>
>> Dave
>> /dps
>>
>>
>>
>>
>> --
>> 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 <javascript:>.
>> 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.
