number in the sequence, then use that number as
the key for my insert.
--Jay Gardner
-Original Message-
From: Jay Gardner [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 07, 2002 12:02 AM
To: Tomcat Users List
Subject: RE: saving object
What database are you using?
-Original Message
I have done this with some row_id defined to be auto-insert on mysql.
With auto-insert you know it will be unique but might want to make
that a constraint.
insert .blah blah
select max(row_id) - yields the number of the last tx.
row_id is just an example for your purpses.
Good luck
At
What database are you using?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 06, 2002 9:15 PM
To: Tomcat Users List
Subject: Re: saving object
I have done this with some row_id defined to be auto-insert on mysql.
With auto-insert you know
Can you use a stored procedure to inset the row? The stored procedure can
query the id of the row just inserted and pass it back to you as an output
parameter.
Jim
-Original Message-
From: Henry [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 3:42 PM
To: Tomcat Users List
Would you give me an example? I am not familiar with stored procesure
though...
thanx a lot!
- Original Message -
From: Jim Urban [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 3:06 PM
Subject: RE: saving object
Can you use a stored procedure
' flag
back somewhere until client server are sync'ed.
Cheers,
Danny.
---
Danny Ayers
stuff http://www.isacat.net /stuff
-Original Message-
From: Henry [mailto:[EMAIL PROTECTED]]
Sent: 06 April 2002 00:15
To: Tomcat Users List
Subject: Re: saving object
Would you give me an example? I am