[Zope] insert_id with MySQL an Z SQL Method

Ferhat Ayaz ferhatayaz at yahoo.com
Fri Sep 1 15:44:45 EDT 2006


Thanks for the answers. The keyword I missed was
<dtml-var sql_delimiter>. Now it's working. Here my
complete Z SQL Method:

-----------------------
insert into categories (parent_id,logo,active) values
(
 <dtml-sqlvar parent_id type="int">,
 <dtml-sqlvar logo type="string">,
 <dtml-sqlvar active type="int">
)
<dtml-var sql_delimiter>
select LAST_INSERT_ID() as table_id_seq
-----------------------

--- "Allen Schmidt Sr." <aschmidt at fredericksburg.com>
wrote:

> 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 )
> > 
> > 
> _______________________________________________
> 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 )
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the Zope mailing list