CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Dropping Connection

Print topic Send  topic

Author Message
sysdfg

Posts: 14
Posted: 06/23/2004, 9:24 AM

I have a page that has 78 fields to input. From time to time when you press the Add button, it kicks you out and you have to relogin and all the data you typed in is lost. At other times we can input with no problem.

I thought it might be a timeout issue with IIS but the timeout is set to 1800 seconds.

Is there a timeout for codecharge?

Using Windows 2000 server with IIS and a MS Access 2000 database. Clients use NT4 and XP.
View profile  Send private message
DonB
Posted: 06/23/2004, 10:08 AM

I just happened to have discussed this only yesterday:
http://www.gotodon.net/mt/archives/ccbth/2004/06/index.html#000002

Here's what I ended up with (below). I happen to save the login information
in cookies when they log in, so I can call the login function silently if
the session goes away (signalled by the CCGetUserID() function returning the
special value of Empty). I didn't get fancy and just hardcoded the cookie
names I used. I hate modifying the common code, but saw no way around that
since the security check happens before any event handlers that would let me
intercept and perform the login.


'CCSecurityAccessCheck @0-8A7701BE
Function CCSecurityAccessCheck(GroupsAccess)
Dim ErrorType
Dim GroupID

' Check for, and recover from, a lost session
If CCGetUserID() = Empty Then
If Request.Cookies("Userlogin") <> Empty And Request.Cookies("Userpass") <>
Empty Then
Call CCLoginUser(Request.Cookies("Userlogin"),Request.Cookies("Userpass"))
End If
' End recovery

End If
ErrorType = "success"
If IsEmpty(CCGetUserID()) Then
ErrorType = "notLogged"
Else
GroupID = CCGetGroupID()
If IsEmpty(GroupID) Then
ErrorType = "groupIDNotSet"
Else
If NOT CCUserInGroups(GroupID, GroupsAccess) Then
ErrorType = "illegalGroup"
End If
End If
End If
CCSecurityAccessCheck = ErrorType
End Function
'End CCSecurityAccessCheck


--
DonB

logging at http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net


"sysdfg" <sysdfg@forum.codecharge> wrote in message
news:640d9aed9b83f1@news.codecharge.com...
> I have a page that has 78 fields to input. From time to time when you
press the
> Add button, it kicks you out and you have to relogin and all the data you
typed
> in is lost. At other times we can input with no problem.
>
> I thought it might be a timeout issue with IIS but the timeout is set to
1800
> seconds.
>
> Is there a timeout for codecharge?
>
> Using Windows 2000 server with IIS and a MS Access 2000 database. Clients
use
> NT4 and XP.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

Tuong Do
Posted: 06/23/2004, 11:10 PM

Hi Don,
You don't have to modify the common code for this

What you have to do is in the before show event of your login page
Check for the cookies
If it exists then do your silent login then redirect it back to the referer
page.


"DonB" <~ccbth~@gotodon.com> wrote in message
news:cbcde8$9pv$1@news.codecharge.com...
> I just happened to have discussed this only yesterday:
> http://www.gotodon.net/mt/archives/ccbth/2004/06/index.html#000002
>
> Here's what I ended up with (below). I happen to save the login
information
> in cookies when they log in, so I can call the login function silently if
> the session goes away (signalled by the CCGetUserID() function returning
the
> special value of Empty). I didn't get fancy and just hardcoded the cookie
> names I used. I hate modifying the common code, but saw no way around
that
> since the security check happens before any event handlers that would let
me
> intercept and perform the login.
>
>
> 'CCSecurityAccessCheck @0-8A7701BE
> Function CCSecurityAccessCheck(GroupsAccess)
> Dim ErrorType
> Dim GroupID
>
> ' Check for, and recover from, a lost session
> If CCGetUserID() = Empty Then
> If Request.Cookies("Userlogin") <> Empty And Request.Cookies("Userpass")
<>
> Empty Then
> Call
CCLoginUser(Request.Cookies("Userlogin"),Request.Cookies("Userpass"))
> End If
> ' End recovery
>
> End If
> ErrorType = "success"
> If IsEmpty(CCGetUserID()) Then
> ErrorType = "notLogged"
> Else
> GroupID = CCGetGroupID()
> If IsEmpty(GroupID) Then
> ErrorType = "groupIDNotSet"
> Else
> If NOT CCUserInGroups(GroupID, GroupsAccess) Then
> ErrorType = "illegalGroup"
> End If
> End If
> End If
> CCSecurityAccessCheck = ErrorType
> End Function
> 'End CCSecurityAccessCheck
>
>
> --
> DonB
>
> logging at http://www.gotodon.com/ccbth, and blogging at
> http://ccbth.gotodon.net
>
>
> "sysdfg" <sysdfg@forum.codecharge> wrote in message
>news:640d9aed9b83f1@news.codecharge.com...
> > I have a page that has 78 fields to input. From time to time when you
> press the
> > Add button, it kicks you out and you have to relogin and all the data
you
> typed
> > in is lost. At other times we can input with no problem.
> >
> > I thought it might be a timeout issue with IIS but the timeout is set to
> 1800
> > seconds.
> >
> > Is there a timeout for codecharge?
> >
> > Using Windows 2000 server with IIS and a MS Access 2000 database.
Clients
> use
> > NT4 and XP.
> > ---------------------------------------
> > Sent from YesSoftware forum
> > http://forums.codecharge.com/
> >
>
>

DonB
Posted: 06/24/2004, 8:05 AM

But that means every page has to modified, so rather than go back and change
all the existing pages (and having to remember to do this for new ones later
on) I changed the common function.


--
DonB

logging at http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net


"Tuong Do" <tuongdo@hotmail.com> wrote in message
news:cbdr9d$ceb$1@news.codecharge.com...
> Hi Don,
> You don't have to modify the common code for this
>
> What you have to do is in the before show event of your login page
> Check for the cookies
> If it exists then do your silent login then redirect it back to the
referer
> page.
>
>
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:cbcde8$9pv$1@news.codecharge.com...
> > I just happened to have discussed this only yesterday:
> > http://www.gotodon.net/mt/archives/ccbth/2004/06/index.html#000002
> >
> > Here's what I ended up with (below). I happen to save the login
> information
> > in cookies when they log in, so I can call the login function silently
if
> > the session goes away (signalled by the CCGetUserID() function returning
> the
> > special value of Empty). I didn't get fancy and just hardcoded the
cookie
> > names I used. I hate modifying the common code, but saw no way around
> that
> > since the security check happens before any event handlers that would
let
> me
> > intercept and perform the login.
> >
> >
> > 'CCSecurityAccessCheck @0-8A7701BE
> > Function CCSecurityAccessCheck(GroupsAccess)
> > Dim ErrorType
> > Dim GroupID
> >
> > ' Check for, and recover from, a lost session
> > If CCGetUserID() = Empty Then
> > If Request.Cookies("Userlogin") <> Empty And
Request.Cookies("Userpass")
> <>
> > Empty Then
> > Call
> CCLoginUser(Request.Cookies("Userlogin"),Request.Cookies("Userpass"))
> > End If
> > ' End recovery
> >
> > End If
> > ErrorType = "success"
> > If IsEmpty(CCGetUserID()) Then
> > ErrorType = "notLogged"
> > Else
> > GroupID = CCGetGroupID()
> > If IsEmpty(GroupID) Then
> > ErrorType = "groupIDNotSet"
> > Else
> > If NOT CCUserInGroups(GroupID, GroupsAccess) Then
> > ErrorType = "illegalGroup"
> > End If
> > End If
> > End If
> > CCSecurityAccessCheck = ErrorType
> > End Function
> > 'End CCSecurityAccessCheck
> >
> >
> > --
> > DonB
> >
> > logging at http://www.gotodon.com/ccbth, and blogging at
> > http://ccbth.gotodon.net
> >
> >
> > "sysdfg" <sysdfg@forum.codecharge> wrote in message
> >news:640d9aed9b83f1@news.codecharge.com...
> > > I have a page that has 78 fields to input. From time to time when you
> > press the
> > > Add button, it kicks you out and you have to relogin and all the data
> you
> > typed
> > > in is lost. At other times we can input with no problem.
> > >
> > > I thought it might be a timeout issue with IIS but the timeout is set
to
> > 1800
> > > seconds.
> > >
> > > Is there a timeout for codecharge?
> > >
> > > Using Windows 2000 server with IIS and a MS Access 2000 database.
> Clients
> > use
> > > NT4 and XP.
> > > ---------------------------------------
> > > Sent from YesSoftware forum
> > > http://forums.codecharge.com/
> > >
> >
> >
>
>

Tony Do
Posted: 06/25/2004, 5:04 PM

Hi Don,
No you only have to modify the login page only one page (every page is
redirected to this page when the session is time out )



"DonB" <~ccbth~@gotodon.com> wrote in message
news:cbeqj4$6bi$1@news.codecharge.com...
> But that means every page has to modified, so rather than go back and
change
> all the existing pages (and having to remember to do this for new ones
later
> on) I changed the common function.
>
>
> --
> DonB
>
> logging at http://www.gotodon.com/ccbth, and blogging at
> http://ccbth.gotodon.net
>
>
> "Tuong Do" <tuongdo@hotmail.com> wrote in message
>news:cbdr9d$ceb$1@news.codecharge.com...
> > Hi Don,
> > You don't have to modify the common code for this
> >
> > What you have to do is in the before show event of your login page
> > Check for the cookies
> > If it exists then do your silent login then redirect it back to the
> referer
> > page.
> >
> >
> > "DonB" <~ccbth~@gotodon.com> wrote in message
> >news:cbcde8$9pv$1@news.codecharge.com...
> > > I just happened to have discussed this only yesterday:
> > > http://www.gotodon.net/mt/archives/ccbth/2004/06/index.html#000002
> > >
> > > Here's what I ended up with (below). I happen to save the login
> > information
> > > in cookies when they log in, so I can call the login function silently
> if
> > > the session goes away (signalled by the CCGetUserID() function
returning
> > the
> > > special value of Empty). I didn't get fancy and just hardcoded the
> cookie
> > > names I used. I hate modifying the common code, but saw no way around
> > that
> > > since the security check happens before any event handlers that would
> let
> > me
> > > intercept and perform the login.
> > >
> > >
> > > 'CCSecurityAccessCheck @0-8A7701BE
> > > Function CCSecurityAccessCheck(GroupsAccess)
> > > Dim ErrorType
> > > Dim GroupID
> > >
> > > ' Check for, and recover from, a lost session
> > > If CCGetUserID() = Empty Then
> > > If Request.Cookies("Userlogin") <> Empty And
> Request.Cookies("Userpass")
> > <>
> > > Empty Then
> > > Call
> > CCLoginUser(Request.Cookies("Userlogin"),Request.Cookies("Userpass"))
> > > End If
> > > ' End recovery
> > >
> > > End If
> > > ErrorType = "success"
> > > If IsEmpty(CCGetUserID()) Then
> > > ErrorType = "notLogged"
> > > Else
> > > GroupID = CCGetGroupID()
> > > If IsEmpty(GroupID) Then
> > > ErrorType = "groupIDNotSet"
> > > Else
> > > If NOT CCUserInGroups(GroupID, GroupsAccess) Then
> > > ErrorType = "illegalGroup"
> > > End If
> > > End If
> > > End If
> > > CCSecurityAccessCheck = ErrorType
> > > End Function
> > > 'End CCSecurityAccessCheck
> > >
> > >
> > > --
> > > DonB
> > >
> > > logging at http://www.gotodon.com/ccbth, and blogging at
> > > http://ccbth.gotodon.net
> > >
> > >
> > > "sysdfg" <sysdfg@forum.codecharge> wrote in message
> > >news:640d9aed9b83f1@news.codecharge.com...
> > > > I have a page that has 78 fields to input. From time to time when
you
> > > press the
> > > > Add button, it kicks you out and you have to relogin and all the
data
> > you
> > > typed
> > > > in is lost. At other times we can input with no problem.
> > > >
> > > > I thought it might be a timeout issue with IIS but the timeout is
set
> to
> > > 1800
> > > > seconds.
> > > >
> > > > Is there a timeout for codecharge?
> > > >
> > > > Using Windows 2000 server with IIS and a MS Access 2000 database.
> > Clients
> > > use
> > > > NT4 and XP.
> > > > ---------------------------------------
> > > > Sent from YesSoftware forum
> > > > http://forums.codecharge.com/
> > > >
> > >
> > >
> >
> >
>
>


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.