[Zope-DB] returning id of an inserted record

Tuttle, Gene cetuttle at rottlundhomes.com
Thu Jun 10 13:05:17 EDT 2004


using a zsql method with the following query
insert into buyer
(
buyer_name_last,
buyer_name_first,
buyer_name_mi,
buyer_phone_home, 
buyer_phone_work,
buyer_phone_cell, 
buyer_email_primary,
buyer_address_street,
buyer_address_city,
buyer_address_state,
buyer_address_zip) 
Values(
<dtml-sqlvar buyer_name_first type="string">,
<dtml-sqlvar buyer_name_last type="string">,
<dtml-sqlvar buyer_name_mi type="string">,
<dtml-sqlvar buyer_phone_home type="string">,
<dtml-sqlvar buyer_phone_work type="string">,
<dtml-sqlvar buyer_phone_cell type="string">,
<dtml-sqlvar buyer_email_primary type="string">,
<dtml-sqlvar buyer_address_street type="string">,
<dtml-sqlvar buyer_address_city type="string">,
<dtml-sqlvar buyer_address_state type="string">,
<dtml-sqlvar buyer_address_zip type="string">
)
<dtml-var sql_delimiter>
select buyer_id, buyer_name_first, buyer_name_last from buyer where buyer_id
= currval('buyer_buyer_id_seq')
 
When I test this it works.  
my question is how do I use this in DTML?

I do this..
<dtml-call "add_buyer(REQUEST)">

but how do I get the results? ( mainly the buyer_id which is a database
generated sequence.)

Thanks
Gene Tuttle



More information about the Zope-DB mailing list