[Zope] insert_id with MySQL an Z SQL Method

[Allen Schmidt Sr.]

I have been using this successfully for a while. Don't remember where I 
found out about it though:

insert stuff...
<dtml-var sql_delimiter>

select alert_id from entertainment_alerts
   where alert_id = @@identity


Allen



Cliff Ford wrote:

> Search the mailing list archives for July - there were several 
> contributions to this question. Roughly:
> 
> insert ...
> <dtml-var sql_delimiter>
> select LAST_INSERT_ID() as table_id_seq
> 
> Cliff
> 
> Ferhat Ayaz wrote:
> 
>> Hi,
>>
>> I have a Z SQL Method with an insert expression. To
>> the inserted row will be assigned an auto_increment
>> id. How can I get the last inserted id?
>>
>> I tryed the following both commands in one Z SQL
>> method. Unfortunatly this produces an error.
>>
>> insert into categories (parent_id,logo,active) values
>> (
>>  <dtml-sqlvar parent_id type="int">,
>>  <dtml-sqlvar logo type="string">,
>>  <dtml-sqlvar active type="int">,
>> );
>>
>> SELECT currval('table_id_seq');
>>
>> Thanks for your helps
>>
>> Greets,
>> Ferhat
>>
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Tired of spam?  Yahoo! Mail has the best spam protection around 
>> http://mail.yahoo.com _______________________________________________
>> Zope maillist  -  Zope at zope.org
>> http://mail.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists -  http://mail.zope.org/mailman/listinfo/zope-announce
>>  http://mail.zope.org/mailman/listinfo/zope-dev )
> 
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )
> 
>