[thelist] Key ID of Record Just Created?

[Chris Hayes]

>> DIM valDocID as Integer = SELECT @@IDENTITY
>
> I don't know anything about .NET syntax, but basically yes, you will have 
> to
> run that SELECT query, and assign the results to a variable


Don'y know if it applies to ASP with MS/MY SQL but might advise a 
transaction lock around the insert and the select to ensure you retrieve the 
correct ID.

Anybody?