[thelist] Key ID of Record Just Created?

Chris Hayes chris at lwcdial.net
Tue Aug 23 16:30:11 CDT 2005

>> 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.


More information about the thelist mailing list