id=db.db_users.insert( dbu_name=request.vars.nick,
dbu_email=request.vars.email,
dbu_password=request.vars.pass1,
dbu_city=request.vars.city,
dbu_referral=request.vars.referral)
USERID_FROM_RECORD_ABOVE=id
db(db.db_users.id==USERID_FROM_RECORD_ABOVE).select()[0].update_record
(\
dbu_name=request.vars.nick,\
dbu_email=request.vars.email,\
dbu_password=request.vars.pass1,\
dbu_city=request.vars.city,\
dbu_referral=request.vars.referral)
On 22 Apr, 20:54, Iceberg <iceb...@21cn.com> wrote:
> Havn't you read this?http://www.web2py.com/examples/default/dal
>
> On Apr23, 9:21am, waTR <roman.proje...@gmail.com> wrote:
>
> > I am trying to have a controller insert a db record, and then update
> > the same record. However, in order to update the record just created
> > by a user session, I need to use the db record's id number. The
> > problem is, I don't know how to get the id number from the record just
> > created by a user session.
>
> > Help?
>
> > Here is the pseudo code:
>
> > db.db_users.insert( dbu_name=request.vars.nick,
> > dbu_email=request.vars.email,
> > dbu_password=request.vars.pass1,
> > dbu_city=request.vars.city,
> > dbu_referral=request.vars.referral)
>
> > db(db.db_users.id==USERID_FROM_RECORD_ABOVE).select()[0].update_record
> > (\
> > dbu_name=request.vars.nick,\
> > dbu_email=request.vars.email,\
> > dbu_password=request.vars.pass1,\
> > dbu_city=request.vars.city,\
> > dbu_referral=request.vars.referral)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
