How to update MDB in Session_OnEnd instantly

My code is






What confuse me is that db is not update after
session_onend triggerred!

Even if i stop the Site, i can not read the
fresh ip data.

But when i stop w3svc service,
yes, i can read all the ip data list!

Why not session_onend update mdb immediately?

Maxixi

Re: How to update MDB in Session_OnEnd instantly

First, you should never use ADO objects at application scope.
http://www.aspfaq.com/show.asp?id=2053

Second, session_onend is not considered reliable
http://www.aspfaq.com/show.asp?id=2078


--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"maxixi" wrote in message
news:OGxbv1r8EHA.2180@TK2MSFTNGP12.phx.gbl...
> My code is
>
>
>
>
>
>
> What confuse me is that db is not update after
> session_onend triggerred!
>
> Even if i stop the Site, i can not read the
> fresh ip data.
>
> But when i stop w3svc service,
> yes, i can read all the ip data list!
>
> Why not session_onend update mdb immediately?
>
> Maxixi
>
>

Re: How to update MDB in Session_OnEnd instantly

Third - If the session has ended, this will not work..
> DefaultRecordset("IP") = Session("USER_IP")


Bob Lehmann

"maxixi" wrote in message
news:OGxbv1r8EHA.2180@TK2MSFTNGP12.phx.gbl...
> My code is
>
>
>
>
>
>
> What confuse me is that db is not update after
> session_onend triggerred!
>
> Even if i stop the Site, i can not read the
> fresh ip data.
>
> But when i stop w3svc service,
> yes, i can read all the ip data list!
>
> Why not session_onend update mdb immediately?
>
> Maxixi
>
>

Re: How to update MDB in Session_OnEnd instantly

I want to track hit history.
But without Session_OnEnd,
how to save record click history?

"Bob Lehmann" дÈëÏûÏ¢ news:OAdVmdz8EHA.3504@TK2MSFTNGP12.phx.gbl...
> Third - If the session has ended, this will not work..
> > DefaultRecordset("IP") = Session("USER_IP")
>
>
> Bob Lehmann
>
> "maxixi" wrote in message
> news:OGxbv1r8EHA.2180@TK2MSFTNGP12.phx.gbl...
> > My code is
> >
> >
> >
> >
> >
> >
> > What confuse me is that db is not update after
> > session_onend triggerred!
> >
> > Even if i stop the Site, i can not read the
> > fresh ip data.
> >
> > But when i stop w3svc service,
> > yes, i can read all the ip data list!
> >
> > Why not session_onend update mdb immediately?
> >
> > Maxixi
> >
> >
>
>

Re: How to update MDB in Session_OnEnd instantly

I'm not sure what you're talking about.

If the session has ended, then the values held in session variables are
gone.

Bob Lehmann

"maxixi" wrote in message
news:eNAcwh18EHA.2196@TK2MSFTNGP14.phx.gbl...
> I want to track hit history.
> But without Session_OnEnd,
> how to save record click history?
>
> "Bob Lehmann" дÈëÏûÏ¢
news:OAdVmdz8EHA.3504@TK2MSFTNGP12.phx.gbl...
> > Third - If the session has ended, this will not work..
> > > DefaultRecordset("IP") = Session("USER_IP")
> >
> >
> > Bob Lehmann
> >
> > "maxixi" wrote in message
> > news:OGxbv1r8EHA.2180@TK2MSFTNGP12.phx.gbl...
> > > My code is
> > >
> > >
> > >
> > >
> > >
> > >
> > > What confuse me is that db is not update after
> > > session_onend triggerred!
> > >
> > > Even if i stop the Site, i can not read the
> > > fresh ip data.
> > >
> > > But when i stop w3svc service,
> > > yes, i can read all the ip data list!
> > >
> > > Why not session_onend update mdb immediately?
> > >
> > > Maxixi
> > >
> > >
> >
> >
>
>

Re: How to update MDB in Session_OnEnd instantly

Are you trying to track page hit history or session history?

For page-hits you can use the IIS log or include code in each page to log to
a database or file.

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"maxixi" wrote in message
news:eNAcwh18EHA.2196@TK2MSFTNGP14.phx.gbl...
>I want to track hit history.
> But without Session_OnEnd,
> how to save record click history?
>
> "Bob Lehmann" дÈëÏûÏ¢
> news:OAdVmdz8EHA.3504@TK2MSFTNGP12.phx.gbl...
>> Third - If the session has ended, this will not work..
>> > DefaultRecordset("IP") = Session("USER_IP")
>>
>>
>> Bob Lehmann
>>
>> "maxixi" wrote in message
>> news:OGxbv1r8EHA.2180@TK2MSFTNGP12.phx.gbl...
>> > My code is
>> >
>> >
>> >
>> >
>> >
>> >
>> > What confuse me is that db is not update after
>> > session_onend triggerred!
>> >
>> > Even if i stop the Site, i can not read the
>> > fresh ip data.
>> >
>> > But when i stop w3svc service,
>> > yes, i can read all the ip data list!
>> >
>> > Why not session_onend update mdb immediately?
>> >
>> > Maxixi
>> >
>> >
>>
>>
>
>