[Zope] ZSQL - finding the id of what you just inserted?

[Hannu Krosing]

The Doctor What wrote:
> 
> Howdy again....
> 
> I use a dtml-call to call a zsql object that does an insert.  I
> don't specify ID because ID is auto-sequenced by the DB.
> 
> How can I find out what the ID of that just inserted object is so I
> can do more operations on it?

I usually have my insert ZSQL-method return it

insert into mytable(name) values('myname')
;
select nextval('mytable_id_seq')


----------------
Hannu