Re: FN-FORUM asp problem...Help!

date posted 12th January 2001 16:07

if Request.ServerVariables("REQUEST_METHOD")="POST" then

username=trim(Request.Form("username"))
password=trim(Request.Form("password"))

sql="SELECT * FROM tablename WHERE username='"&username&"'"

set rs=server.CreateObject("adodb.recordset")

rs.Open sql, conn, adOpenStatic

if rs.RecordCount=0 then Response.Redirect("usernot.htm")

if rs.RecordCount>0 then

if rs("password")password then Response.Redirect("passwordnot.htm")

session(session.SessionID)=rs("user_level")

Response.Redirect("management_logged.htm")

end if

hth

dave ecky

David Eckersall
Kinetic North Limited
A member of the Wize Group of companies
Reg Co No 4100142
Reg Office and Business Address
St James House, Wellington Road North
Stockport SK4 2QN
Office Tel - 00 44 161 975 5900
Office Fax - 00 44 161 975 5924
Web - http://www.kineticnorth.com

This communication contains information which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s) please note that any form of
distribution, copying or use of this communication or the information in it
is strictly prohibited and may be unlawful. If you have received this
communication in error please return it to the sender. Internet e-mails are
not necessarily secure. Kinetic North Limited does not accept responsibility
for changes made to this message after it was sent. Our messages are checked
for viruses but please note that we do not accept liability for any viruses
which may be transmitted in or with this message.

----- Original Message -----
From: [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, January 12, 2001 3:04 PM
Subject: FN-FORUM asp problem...Help!


> Hi all,
>
> I am doing a security check (user name and password). I can get it to
> redirect if both are true, however does anyone know what to put if both
are
> true and therefore redirect them to the protected area?
>
> here's the script I have at present. It works for the
>
> BOF redirection but not the if correct redirection.
> If Recordset1.BOF Then
> Response.Redirect "failedsecurity.asp"
> Else
> Response.Redirect "index1.htm"
> End If
>
> any help would be much appreciated
>
> cheers
> Rob
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html