[thelist] Pausing ASP script when no acces to SQL server

jason.handby jason.handby at corestar.co.uk
Wed Aug 16 09:10:18 CDT 2006

Hi Chris,

> I require to pause an ASP script for around 1 second after 
> doing a database insert so I can grab the unique ID from the 
> new record in an access database
> using: SELECT MAX (itemID) AS maxID FROM tblItems"
> If I don't pause the script I get the previous maxID.

You absolutely don't want to do this!!!

Why not use @@IDENTITY to get the unique ID of the last inserted record?



More information about the thelist mailing list