server behaviors >> user authentication >> check names Ranjan
- A Dreamweaver Community
Join today for your answers in web design
- A Dreamweaver Community
Join today for your answers in web design
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
User Authentication - check username question
- Thread starter bluranj
- Start date
[tt]
bluranj's suggestion is the default way dreamweaver handles this and a good one.
Here's how I handle it:
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL"
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString
MM_valUsername=CStr(Request.Form("username")
If MM_valUsername <> "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="default.asp"
MM_redirectLoginFailed="login.asp?valid=false"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_MYDSN_STRING
MM_rsUser.Source = "SELECT *"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM dbo.MyTable WHERE username='" & MM_valUsername &"' AND password='" & CStr(Request.Form("password") & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
' username and password match - this is a valid user
Session("MM_Username" = MM_valUsername...
etc, etc, etc...
%>
Then on your just below your <form> tag do this:
<% if request("valid" = "false" then
response.write "<font color=red>Login failed. Please try again.</font>"
end if %>
bluranj's suggestion is the default way dreamweaver handles this and a good one.
Here's how I handle it:
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL"
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString
MM_valUsername=CStr(Request.Form("username"
)If MM_valUsername <> "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="default.asp"
MM_redirectLoginFailed="login.asp?valid=false"
MM_flag="ADODB.Recordset"
set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_MYDSN_STRING
MM_rsUser.Source = "SELECT *"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM dbo.MyTable WHERE username='" & MM_valUsername &"' AND password='" & CStr(Request.Form("password"
) & "'"MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open
If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
' username and password match - this is a valid user
Session("MM_Username"
= MM_valUsername...etc, etc, etc...
%>
Then on your just below your <form> tag do this:
<% if request("valid"
= "false" thenresponse.write "<font color=red>Login failed. Please try again.</font>"
end if %>
* * * * * * * * * * *
<%=Tony%>
<%=Tony%>
- Status
Similar threads
- Locked
- Question