CommitTransComplete 2

[Deadline]

Hi,
I am trying to update two three tables and if all of them were successfully updated, I need to send an email to the user..

I am using cn.BeginTrans and cn.CommitTrans route. My backend is SQL Server 7.

Why doesn't the cn.CommitTransComplete method work for me ?
I mean , I have given the event script inside a <%%> tags. Even then it doesn't work, why ? Here is a code snippet:

<%

Sub cn_CommitTransComplete
'THE AUTOEMAIL-
Set objCDOMail = Server.CreateObject(&quot;CDONTS.NewMail&quot;)
'.... and so on...
%>

In advance, Thanks!

RR

 

[foxbox]

[i skipped transactions thusfar; so maybe this is completly wrong]. Maybe this page helps:

http://aspemporium.com/aspEmporium/tutorials/aspEvents.asp

br
Gerard

 

[steveflit]

Have you used the withevents keyword
Dim WithEvents CN as ADODB.Connection

 

[Deadline]

Steve,
Nope.. I haven't done that.. Will that help ? Thanks!

RR

 

[Deadline]

Hi Steve and FoxBox,

DOes ASP support

WithEvents

Keyword ? Thanks!

RR

 

[foxbox]

? this is a .net example:

http://www.asp101.com/articles/kaushal/aspnethelloworld/default.asp

br
Gerard