Re: grabbing the id of an item just entered into DB

[G]

This will not necessarily work. If a concurrent user has inserted something between the time your process did, and the retrieval, you are not gauranteed to be retreiving the correct row.

either use @@Identity or some sort of unique identifier in the retrieval, such as "max(primarykey) and userid" to ensure you get the last record inserted by THIS user.

Brian
  ----- Original Message -----
  From: Milan Mushran
  To: CF-Talk
  Sent: Monday, July 26, 2004 10:07 AM
  Subject: Re: grabbing the id of an item just entered into DB

  SELECT MAX(id) from tablename

  Daniel Farmer <[EMAIL PROTECTED]> wrote:Hi gang.... I remember hearing something a while back where someone wanted
  to grab the id of an item they just entered into the database.... all in one
  sql statement.

  Does anyone remember the sql for that?
  ---------------------------------

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---