[EMAIL PROTECTED] wrote:
sql:transaction dataSource=${test}
sql:update var=InsertDriver
INSERT INTO REQUEST_OFFER (RO_FK_CUST_PHONENO, RO_TYPE
VALUES (?,?)
sql:param value=${Customer.phone_no}/
sql:param value=SINGLE/
Hey Lukasz,
This is generally speaking an issue of SQL databases. Not all databases have a
mechanism for creating keys this way and therefore also not for retrieveing the keys
inserted this way. AFAIK there is no SQL standard addressing this issue and therefore
there probably won't be any
If you are using MySQL you can use
SELECT LAST_INSERT_ID() to get the id value. Just issue that query within the same
transaction after the insert.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/25/03 7:52 AM
Subject: SQL INSERT
Dear Taglibs users,
I am
Thanks a lot,
Iam using mysql and it works fine :)
regards,
Lukasz
If you are using MySQL you can use
SELECT LAST_INSERT_ID() to get the id value. Just issue that query
within the same transaction after the insert.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]