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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MULTIUSER PASSWORD/LOGIN
- Thread starter Marijan
- Start date
It is using databases, create a form with login and password and submit then link to your database and check the details......
This page called after you enter login and password!..
' Open the connection and Create the record set
set dbProfile = server.createobject("adodb.connection"
strConnection = "Enter your provide information here"
dbProfile.open (strConnection)
set rsProfile = server.CreateObject("adodb.recordset"
' Build the SQL stored procedure to retrieve the customer username and password I am using Stored procedures
sql = "execute sp_RetrieveLogin '" & customer_username & _
"', '" & customer_password & "'"
' Retrieve the record set.
set rsProfile = dbProfile.Execute(sql)
if rsProfile.EOF = false then
' go to page that is correct
Response.redirect "loginresult.asp?"
else
' Error
Response.Redirect "loginerror.asp?" end if
%>
This page called after you enter login and password!..
' Open the connection and Create the record set
set dbProfile = server.createobject("adodb.connection"
strConnection = "Enter your provide information here"
dbProfile.open (strConnection)
set rsProfile = server.CreateObject("adodb.recordset"
' Build the SQL stored procedure to retrieve the customer username and password I am using Stored procedures
sql = "execute sp_RetrieveLogin '" & customer_username & _
"', '" & customer_password & "'"
' Retrieve the record set.
set rsProfile = dbProfile.Execute(sql)
if rsProfile.EOF = false then
' go to page that is correct
Response.redirect "loginresult.asp?"
else
' Error
Response.Redirect "loginerror.asp?" end if
%>
- Status
Similar threads
