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

[Chris Dempsey]

> I've been able to use @@IDENTITY with Access in the past.Thanks for the
confirmation - must have implemented the code incorrectly.

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

I've been able to use @@IDENTITY with Access in the past.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Chris Dempsey
> Sent: Wednesday, August 16, 2006 11:23 AM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Pausing ASP script when no acces to SQL server
> -SOLVED
> 
> 
> Couldn't get @@IDENTITY to work on the Access Database - it 
> keeps returning
> value of '0' as the new ID - although I did find the following which
> provided an alternative:
> 
> http://support.microsoft.com/default.aspx/kb/221931
> 
> Can anyone confirm that as Jason and 
> http://www.drdev.net/article06Print.htm
> say, that @@Identity can be used on Access?  All I got were 
> values of '0'
> and no errors.
> 
> Thanks anyway Jason - your first link led me to find the link to MS KB
> Article which worked for me.
> 
> Chris.
> 
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Chris Dempsey
> Sent: 16 August 2006 15:30
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Pausing ASP script when no acces to SQL server
> 
> > 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 ! 
> 
> -- 
> 
> * * 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 ! 
> 
> -- 
> 
> * * 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 ! 
> 
-- 

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