Was not aware of this Larry -Thanks. Will try your solution.
Just a thought. If you do use 'SELECT LAST_INSERT_ID()' and
two tables have been auto-incremented which ID does it return?
Alan.
"Learn something NEW everyday"
On Wed, 17 Aug 2005 22:46:19 +0100, Larry Meadors
<[EMAIL PROTECTED]> wrote:
NO! That is really, really not thread safe!
Imagine what happens when 2 ppl do inserts at the same time...
[insert #1][insert #2][query #1][query #2]
Both [query #1] and [query #2] return the same id.
Ooops! kaboom!
Larry
On 8/17/05, Alan Hicks <[EMAIL PROTECTED]> wrote:
Hi Brian,
I had the same problem and could not find any working examples. Finally
I
stumbled upon
the query where 'userId' is an auto-generated key in my mysql table. If
you replace the
query you have with this one you should be in business.
SELECT MAX(userId) FROM tb_user
Hope this helps.
Alan.
On Wed, 17 Aug 2005 21:43:05 +0100, Barnett, Brian W.
<[EMAIL PROTECTED]> wrote:
> We've been using SQL Server and are moving to mySQL. Can somebody
tell me
> how to do this for mySql:
>
> <selectKey resultClass="int" keyProperty="id">
> SELECT @@IDENTITY AS id
> </selectKey>
>
> TIA,
> Brian Barnett
>
>
****************************************************************************
> This email may contain confidential material.
> If you were not an intended recipient,
> Please notify the sender and delete all copies.
> We may monitor email to and from our network.
>
****************************************************************************
>
>
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
