This is how it works for MySQL:
insert into table_name (
ItemID,
ItemDate,
etc
)
values
(
dtml-sqlvar ItemID type=int,
dtml-sqlvar ItemDate type=string,
etc
)
dtml-var sql_delimiter
select LAST_INSERT_ID() as BaptismID
You have to have the select LAST_INSERT_ID call in the same query as the
Hi guys, HOW HOW HOW HOW!!! Do I get at the last_insert_id() function, this is driving me absolutely crazy!! Zope docs say use "select last_insert_id()" but it doesn't work, gives me an error about bad SQL syntax around "LIMIT 1000". I tried googling it, I tried searching through other docs. And
Alric Aneron wrote:
Hi guys,
HOW HOW HOW HOW!!!
Do I get at the last_insert_id() function, this is driving me
absolutely crazy!!
Zope docs say use select last_insert_id() but it doesn't work, gives
me an error about bad SQL syntax around LIMIT 1000. I tried
googling it, I tried searching