You can get a ZSQLMethod that's used for inserting to return the last
inserted ID by doing the following:
INSERT ...whatever...
SELECT LAST_INSERT_ID() AS newid
You get the results as you would with any ZSQLMethod:
Inserted ID:
___
Ron Bickers
Logic Etc,
LAST_INSERT_ID is the MySQL way to find out the last inserted id, how
exactly didn't it solve your problem?
phil
- Original Message -
From: "Andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 18 May 2000 00:44
Subject: [Zope] ZSQL-Methods: last inserted id
>
> I wonder how I can fi
> I wonder how I can find out about the last inserted id of a row in my
> mysql-database, which I inserted through a ZSQL-Method...
>
> I tried mysql's built-in function LAST_INSERT_ID(), but that did not solve
> my problem...
It should. Create a DTML method called, say 'select_last_id':
selec