[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