Thanks jeff, thats a question thats been bugging me for a while.
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 10:24
To: Sean O'Donnell; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: ensuring that I'm getting the correct "last in
Gotcha. So far, selecting the last_insert_id() is working. I'll see what the
CF forums have to say.
thanks.
--- Original Message
From: "Jeff Kilbride"
To: "Jonnycattt"
CC:
Subject: Re: Re: ensuring that I'm getting the correct "last insert I
pool, you will be fine.
--jeff
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 8:36 AM
Subject: RE: ensuring that I'm getting the correct "last insert ID"
> if you are using a conn
]]
Sent: 02 May 2002 08:36
To: Sean O'Donnell; [EMAIL PROTECTED]
Subject: Re: ensuring that I'm getting the correct "last insert ID"
But would the same instance of a script drop and pick up different
connections? I haven't done any Java/MySQL work, but anything I've
>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 11:28 AM
Subject: RE: ensuring that I'm getting the correct "last insert ID"
> its used a lot by java. As setting up and closing down connections to the
> database
> is relatively expen
You should not SELECT MAX(userID), you should SELECT LAST_INSERT_ID(),
which gives you
tha last id *generated by your connection* regarless of any others,
This is general purpose. If you are willing to be MySQL specific, both C
and Java
(and, I presume, other languages) allow you to retrieve th
ubject: Re: ensuring that I'm getting the correct "last insert ID"
Admittedly, I'm no expert. What *is* connection pooling?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 11:21 AM
Su
Admittedly, I'm no expert. What *is* connection pooling?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 11:21 AM
Subject: RE: ensuring that I'm getting the correct "last inser
what happens if you are using connection pooling though?
-Original Message-
From: denonymous [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 08:09
To: [EMAIL PROTECTED]
Subject: Re: ensuring that I'm getting the correct "last insert ID"
From: "Jonnycattt" <
From: "Jonnycattt" <[EMAIL PROTECTED]>
> Hi all,
> I know this has been asked a bunch of times, but i need some clarity (new
> mySQL user).
> I have an app that inserts a new user into one table, then inserts some
user
> preferences into another table. the procedure is as follows:
> 1) insert new
10 matches
Mail list logo
