Jan K. van Dalen
|
| Posted: 07/11/2005, 11:17 PM |
|
Hi Everyone,
I need 3 things using .net (vb):
1) How do I filter base on a field (not the userid) contain in the security
table? IOW, everything should be filter by Department No. which is one of
the fields in the security table.
2) I would like for that not to be visible to the user. I'm guessing the
use of a session variable but have read several message discouraging such a
practice. Am I wrong?
3) How do I set a auto-logout after x number of minutes?
|
|
|
 |
wkempees
|
| Posted: 07/12/2005, 1:40 AM |
|
Jan,
In your Login: (from CCSHelp)
Quote :
Create Custom Session Variables
This example shows how to add a custom session variable when a user is
logged in. In this case, we will store the user's name in a session
variable.
Add an On Click event to the 'Login' button of a Login form.
Within the event, add the code below:
Note: In addition to creating the session variable, you should also
clear it when the user logs out.
The place to set your session variable (good practice although to be
used sparsely), e.g. ssn_yr_parm.
Then in the Grids' Properties DataSource press the [...] and in the
Where add a condition XYZ equals ssn_yr_parm type SESSION.
I think that should cover it.
Looking at the code for the grid you will see a CCGetSession() for your
parm.
That's the way you can GET the value yourself.
Autologout will occur at least when session expires.
Autologout when a user closes it's browser is more difficult, you will
have no control.
There are threads in the forum on this subject, will try and find them 4u.
BTW the Help states that you will have to destroy manually crated
session variables yourself in your logout form.
gegroet,
Walter
|
|
|
|
Jan K. van Dalen
|
| Posted: 07/12/2005, 11:35 AM |
|
Hi Walter,
Thank you for the time you take to help us newbies :)
I have decided to start doing .net only (from ASP) and find that is quite
different (in CodeCharge) when it comes to handcoding.
"wkempees" <kempe819@planet.nl> wrote in message
news:davvm2$e3c$1@news.codecharge.com...
> Jan,
>
> In your Login: (from CCSHelp)
> Quote :
> Create Custom Session Variables
> This example shows how to add a custom session variable when a user is
> logged in. In this case, we will store the user's name in a session
> variable.
>
> Add an On Click event to the 'Login' button of a Login form.
> Within the event, add the code below:
> Note: In addition to creating the session variable, you should also clear
> it when the user logs out.
>
>
> The place to set your session variable (good practice although to be used
> sparsely), e.g. ssn_yr_parm.
> Then in the Grids' Properties DataSource press the [...] and in the Where
> add a condition XYZ equals ssn_yr_parm type SESSION.
>
> I think that should cover it.
> Looking at the code for the grid you will see a CCGetSession() for your
> parm.
> That's the way you can GET the value yourself.
>
> Autologout will occur at least when session expires.
> Autologout when a user closes it's browser is more difficult, you will
> have no control.
> There are threads in the forum on this subject, will try and find them 4u.
> BTW the Help states that you will have to destroy manually crated session
> variables yourself in your logout form.
>
> gegroet,
>
> Walter
>
>
|
|
|
|
|
