|
 |
asp_databases thread: ADO Access 97?
Message #1 by "Bernard, Ronald (RWBE)" <RWBE@c...> on Sat, 27 Jan 2001 06:37:41 -0600
|
|
From the wrox book Active Server Pages 3.0 , chapter 8 page 346, the
example at the top of page for getting autonumber
from Access 97 database. Adding one recordset property rs.CursorLocation
adUseServer , and using the code in book with out
the (with , end with) I get a blank or null value for the intID. The record
is inserted into the database and I write it to the client side
after the Update.
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 29 Jan 2001 17:35:06 +1100
|
|
www.adopenstatic.com/faq/fastestautonumber.asp
demonstrates the two ways you can get the autonumber from an Access DB -
either using a Recordset and .AddNew, or using the new @@Identity.
Otherwise, please post the code youa re using.
Cheers
Ken
----- Original Message -----
From: "Bernard, Ronald (RWBE)" <RWBE@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, January 29, 2001 10:47 PM
Subject: [asp_databases] ADO Access 97?
> >From the wrox book Active Server Pages 3.0 , chapter 8 page 346, the
> example at the top of page for getting autonumber
> from Access 97 database. Adding one recordset property rs.CursorLocation
> adUseServer , and using the code in book with out
> the (with , end with) I get a blank or null value for the intID. The
record
> is inserted into the database and I write it to the client side
> after the Update.
Message #3 by "Bernard, Ronald (RWBE)" <RWBE@c...> on Mon, 29 Jan 2001 14:23:29 -0800
|
|
KEN , I cannot get to your URL below.
> -----Original Message-----
> From: Ken Schaefer [SMTP:ken@a...]
> Sent: Monday, January 29, 2001 12:35 AM
> To: ASP Databases
> Subject: [asp_databases] Re: ADO Access 97?
>
> www.adopenstatic.com/faq/fastestautonumber.asp
>
> demonstrates the two ways you can get the autonumber from an Access DB -
> either using a Recordset and .AddNew, or using the new @@Identity.
> Otherwise, please post the code youa re using.
>
> Cheers
> Ken
>
> ----- Original Message -----
> From: "Bernard, Ronald (RWBE)" <RWBE@c...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Monday, January 29, 2001 10:47 PM
> Subject: [asp_databases] ADO Access 97?
>
>
> > >From the wrox book Active Server Pages 3.0 , chapter 8 page 346, the
> > example at the top of page for getting autonumber
> > from Access 97 database. Adding one recordset property rs.CursorLocation
>
> > adUseServer , and using the code in book with out
> > the (with , end with) I get a blank or null value for the intID. The
> record
> > is inserted into the database and I write it to the client side
> > after the Update.
>
>
>
Message #4 by "Ken Schaefer" <ken@a...> on Tue, 30 Jan 2001 11:26:19 +1100
|
|
sorry:
www.adopenstatic.com/experiments/fastestautonumber.asp
Cheers
Ken
----- Original Message -----
From: "Bernard, Ronald (RWBE)" <RWBE@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, January 30, 2001 9:23 AM
Subject: [asp_databases] Re: ADO Access 97?
> KEN , I cannot get to your URL below.
>
> > -----Original Message-----
> > From: Ken Schaefer [SMTP:ken@a...]
> > Sent: Monday, January 29, 2001 12:35 AM
> > To: ASP Databases
> > Subject: [asp_databases] Re: ADO Access 97?
> >
> > www.adopenstatic.com/faq/fastestautonumber.asp
> >
> > demonstrates the two ways you can get the autonumber from an Access DB -
> > either using a Recordset and .AddNew, or using the new @@Identity.
> > Otherwise, please post the code youa re using.
> >
> > Cheers
> > Ken
Message #5 by "Wally Burfine" <oopconsultant@h...> on Tue, 30 Jan 2001 04:12:10 -0000
|
|
Go to:
www.adopenstatic.com/faq/ and click on the link to fastestautonumber
>From: "Bernard, Ronald (RWBE)" <RWBE@c...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Re: ADO Access 97?
>Date: Mon, 29 Jan 2001 14:23:29 -0800
>
>KEN , I cannot get to your URL below.
>
> > -----Original Message-----
> > From: Ken Schaefer [SMTP:ken@a...]
> > Sent: Monday, January 29, 2001 12:35 AM
> > To: ASP Databases
> > Subject: [asp_databases] Re: ADO Access 97?
> >
> > www.adopenstatic.com/faq/fastestautonumber.asp
> >
> > demonstrates the two ways you can get the autonumber from an Access DB -
> > either using a Recordset and .AddNew, or using the new @@Identity.
> > Otherwise, please post the code youa re using.
> >
> > Cheers
> > Ken
> >
> > ----- Original Message -----
> > From: "Bernard, Ronald (RWBE)" <RWBE@c...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Monday, January 29, 2001 10:47 PM
> > Subject: [asp_databases] ADO Access 97?
> >
> >
> > > >From the wrox book Active Server Pages 3.0 , chapter 8 page 346, the
> > > example at the top of page for getting autonumber
> > > from Access 97 database. Adding one recordset property
>rs.CursorLocation
> >
> > > adUseServer , and using the code in book with out
> > > the (with , end with) I get a blank or null value for the intID. The
> > record
> > > is inserted into the database and I write it to the client side
> > > after the Update.
> >
> >
>
|
|
|
View Cart
