On Tuesday, April 19, 2016 at 3:18:10 AM UTC-7, Jack Lodge wrote: > > When i try this method the Item_Request fills in the ID as None > > Please show your code.
/dps > > On Saturday, April 16, 2016 at 5:09:39 PM UTC+1, Richard wrote: >> >> Hello Jack, >> >> You mean you want to pass the id of the inserted record to another >> controller ? >> >> # Controller form 1 >> if form.process(dbio=False).accept: >> id = db.table.insert(**forms.vars) >> session.last_record_id = id >> >> In the next controller you can access the id you store in session >> # Controller form 2 >> session.last_record_id # contains the previous inserted record id >> >> Watchout as session will keep last_record_id for the during of it... So >> you may need to clean it (delete last_record_id from session after second >> controller complete process) to make sure you are always refering to the >> proper id... >> >> Richard >> >> >> >> On Sat, Apr 16, 2016 at 2:19 AM, Dave S <snide...@gmail.com> wrote: >> >>> >>> >>> On Friday, April 15, 2016 at 9:53:35 PM UTC-7, Jack Lodge wrote: >>>> >>>> Im trying to make a Order system for my alevel course work and when im >>>> filling in some forms i make a *Request* then i redirect the user to >>>> the *Item_Request* form to fill in the details there, i need to be >>>> able to get the id of the Request that they just submitted so i can >>>> populate the Item_Request Table. >>>> >>>> I am using Pythonanywhere and web2py >>>> >>>> how would i do this? >>>> >>> >>> One way would be for the item form to record in the session the id >>> returned by its add operation . The order form would then look up that id >>> in the session. >>> >>> /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. >>> 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.
