[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