[thelist] Pausing ASP script when no acces to SQL server -SOLVED
Chris Dempsey
evolt at cubeit.co.uk
Wed Aug 16 10:54:16 CDT 2006
> 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 !
More information about the thelist
mailing list