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." <[EMAIL PROTECTED]> 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@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@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@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 _______________________________________________ Zope maillist - Zope@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 )