id=db.test.insert(a=3)

or uring forms

form=SQLFORM(db.test)
if form.accepts(request.vars):
   response.flash='last id is %s' % form.vars.id

Massimo

On Feb 27, 11:42 pm, weheh <richard_gor...@verizon.net> wrote:
> Let's say I have
>
> db.define_table('test',SQLField('a','integer'))
>
> How do I get the id of the last record with field 'a' that I inserted
> into the db?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to