[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?

  http://support.microsoft.com/kb/232144/EN-US/



Jason



More information about the thelist mailing list