Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Status of an Connection.Execute method in ASP


Message #1 by "Rajesh K S" <rajesh_ks@t...> on Sun, 14 Jan 2001 22:31:58

Hi,



I am working with ADO in ASP area. I have a series of Connection.Execute

methods 

to be performed. Now, the next execute should perform if and only if the

current one has gone through correctly. I do not wish to use the

Transactions approach.



I would highly appreciate if anyone out there could send me suggestions on

how to go about in determining the status of the Connection.Execute on my

ASP script.



Of course, one may say that if the ADODB connection object does not throw

up any errors then the execute has been successful ! But I would want to do

it explicitly and  more 

directly.



Cheers.



Rajesh Singh.





Message #2 by "Wally Burfine" <oopconsultant@h...> on Mon, 15 Jan 2001 05:53:27 -0000
look at the errors on the connection object

objConn.errors



>From: "Rajesh K S" <rajesh_ks@t...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] Status of an Connection.Execute method in ASP

>Date: Mon, 15 Jan 2001 05:57:06 -0800

>

>Hi,

>

>I am working with ADO in ASP area. I have a series of Connection.Execute

>methods

>to be performed. Now, the next execute should perform if and only if the

>current one has gone through correctly. I do not wish to use the

>Transactions approach.

>

>I would highly appreciate if anyone out there could send me suggestions on

>how to go about in determining the status of the Connection.Execute on my

>ASP script.

>

>Of course, one may say that if the ADODB connection object does not throw

>up any errors then the execute has been successful ! But I would want to do

>it explicitly and  more

>directly.

>

>Cheers.

>

>Rajesh Singh.

>

>


  Return to Index