BorisMartian
|
| Posted: 04/02/2004, 12:24 AM |
|
I have a CCS & ASP project which has a basic login form. But, what i would like to do is before the Session variables get created as per a normal sucessful login i would like it to check some other fields in the Users database.
I would like to check if the users account has been suspended by way of checking a True/False field in the Users DB. If the account has been suspended then redirect to the relevant error page.
It would also be useful to check other values and redirect/log accordingly.
If anyone can shed some light on this topic i would appreciate it.
|
|
|
 |
Tony Do
|
| Posted: 04/02/2004, 11:13 PM |
|
If your database support view then instead of using the users tables, you
can
1) create a view on that users table which only contain users that has value
of true in the extra field that you want to implement
2) Point the User Table to the view that you just create.
"BorisMartian" <BorisMartian@forum.codecharge> wrote in message
news:6406d2349ab0f5@news.codecharge.com...
> I have a CCS & ASP project which has a basic login form. But, what i would
like
> to do is before the Session variables get created as per a normal
sucessful
> login i would like it to check some other fields in the Users database.
>
> I would like to check if the users account has been suspended by way of
> checking a True/False field in the Users DB. If the account has been
suspended
> then redirect to the relevant error page.
>
> It would also be useful to check other values and redirect/log
accordingly.
>
> If anyone can shed some light on this topic i would appreciate it.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
anita
|
| Posted: 04/06/2004, 5:17 AM |
|
i want its source code
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/06/2004, 1:59 PM |
|
You can modify the SQL statement in the CCLoginUser function in Common.asp.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
valkr1e
Posts: 12
|
| Posted: 11/25/2004, 12:21 PM |
|
I'm looking for a similar function, but there's a catch to what i'm trying to do. I have a user table with a non-required (nullable) date field for account expiration. the basic premise is that an admin can create a user and set an expiration date for the user account, which allows for giving a user access to the site for a specified amount of time(think: subscription based services, or access to a support site for the duration of a warranty, etc..) it would be fairly simple to create/modify a sql statement to verify that todays date is before the expiration date, however, the only catch is that I want it so that if the field is not populated with information, the account has no expiration date and has unlimited access(admin accounts, partner accounts, lifetime membership accounts) theorhetically i could have the form insert a default date of december 31, 9999 12:01AM but that's not really how i desire to do this. any one care to help point me in the right direction? my project is ASP 3 in CCS2.3
|
|
|
|
darren166
Posts: 24
|
| Posted: 11/26/2004, 4:41 AM |
|
You could just modify the SQL to check that either todays date is before the expiration date OR the expiration date is null.
Either do this in common.asp as Peter suggested or create a view as Tony Do suggested.
Darren
_________________
---
a. w. d. - c o n s u l t i n g
Midnight Oil Consumers. |
|
|
|
|
