insert_id with MySQL an Z SQL Method
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
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 )
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 )
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@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@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
participants (3)
-
Allen Schmidt Sr. -
Cliff Ford -
Ferhat Ayaz