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

Chris Dempsey evolt at cubeit.co.uk
Wed Aug 16 09:29:52 CDT 2006


> Why not use @@IDENTITY
I had seen this come up before but the same article also said it was only
suitable for SQL Server databases??

Will read up on the MS Knowledgebase article you linked.  Thank you.

Chris.

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of jason.handby
Sent: 16 August 2006 15:10
To: thelist at lists.evolt.org
Subject: Re: [thelist] Pausing ASP script when no acces to SQL server

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

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 




More information about the thelist mailing list