i have the following code in the "Sub Session_OnEnd" routine that does not
seem to run.....

Sub Session_OnEnd

strConnect = "Driver={SQL Server};Server=SERVER;Database=database; User
ID=xxxxxx;Pwd=xxxxxxx"

Set objConnEnd = Server.CreateObject("ADODB.Connection")
objConnEnd.Open strConnect

strDelete = "DELETE formdata WHERE formMyCpsID = " & Session.SessionID
objConnEnd.Execute

strDelete objConnEnd.Close
Set objConnEnd = Nothing

End Sub

....can I access the Session.SessionID at this stage or has it already been
killed?

cheers,
cab.

cab wrote on 08 jun 2004 in microsoft.public.inetserver.asp.general:
[color=blue]
> i have the following code in the "Sub Session_OnEnd" routine that does
> not seem to run.....
>
> Sub Session_OnEnd
>
> strConnect = "Driver={SQL Server};Server=SERVER;Database=database;
> User
> ID=xxxxxx;Pwd=xxxxxxx"
>
> Set objConnEnd = Server.CreateObject("ADODB.Connection")
> objConnEnd.Open strConnect
>
> strDelete = "DELETE formdata WHERE formMyCpsID = " &
> Session.SessionID objConnEnd.Execute
>
> strDelete objConnEnd.Close
> Set objConnEnd = Nothing
>
> End Sub
>
> ...can I access the Session.SessionID at this stage or has it already
> been killed?[/color]

I don't know, but you could test this by global.asa:

Sub Session_OnEnd
application("testing") = Session.SessionID & "-!-"
End Sub

===============
In an asp-page test this with:

if application("testing") = "" then
respons.write "No session ended yet. Please try later."
elseif application("testing") = "-!-" then
respons.write "Session.SessionID not available in Session_OnEnd"
else
respons.write "Yes, Session.SessionID is available in Session_OnEnd"
end if

================
not tested ;-}


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

You can't rely on this to fire anyway.

http://www.aspfaq.com/2078
http://www.aspfaq.com/2491

--
http://www.aspfaq.com/
(Reverse address to reply.)




"cab" <cab_spk@hotmail.com> wrote in message
news:40c55fdb$1@duster.adelaide.on.net...[color=blue]
> i have the following code in the "Sub Session_OnEnd" routine that does not
> seem to run.....
>
> Sub Session_OnEnd
>
> strConnect = "Driver={SQL Server};Server=SERVER;Database=database; User
> ID=xxxxxx;Pwd=xxxxxxx"
>
> Set objConnEnd = Server.CreateObject("ADODB.Connection")
> objConnEnd.Open strConnect
>
> strDelete = "DELETE formdata WHERE formMyCpsID = " & Session.SessionID
> objConnEnd.Execute
>
> strDelete objConnEnd.Close
> Set objConnEnd = Nothing
>
> End Sub
>
> ...can I access the Session.SessionID at this stage or has it already been
> killed?
>
> cheers,
> cab.
>
>[/color]

it thought this might have been the case.
i was testing my code below replacing the Session.SessionID with an actual
value in the database.
sometimes the database entry was deleted, but more often it was not.
thanks.


"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:u#Ge49VTEHA.1472@TK2MSFTNGP12.phx.gbl...[color=blue]
> You can't rely on this to fire anyway.
>
> http://www.aspfaq.com/2078
> http://www.aspfaq.com/2491
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "cab" <cab_spk@hotmail.com> wrote in message
> news:40c55fdb$1@duster.adelaide.on.net...[color=green]
> > i have the following code in the "Sub Session_OnEnd" routine that does[/color][/color]
not[color=blue][color=green]
> > seem to run.....
> >
> > Sub Session_OnEnd
> >
> > strConnect = "Driver={SQL Server};Server=SERVER;Database=database; User
> > ID=xxxxxx;Pwd=xxxxxxx"
> >
> > Set objConnEnd = Server.CreateObject("ADODB.Connection")
> > objConnEnd.Open strConnect
> >
> > strDelete = "DELETE formdata WHERE formMyCpsID = " & Session.SessionID
> > objConnEnd.Execute
> >
> > strDelete objConnEnd.Close
> > Set objConnEnd = Nothing
> >
> > End Sub
> >
> > ...can I access the Session.SessionID at this stage or has it already[/color][/color]
been[color=blue][color=green]
> > killed?
> >
> > cheers,
> > cab.
> >
> >[/color]
>
>[/color]