%@ Language=VBScript %> <% dim myconnection dim rs, rs2 dim strlanes dim strstates dim SQLQuery dim theusername dim thepassword dim strtemppassword dim strtempuser dim strdenied strdenied = "N/A" set myconnection = Server.CreateObject("ADODB.Connection") myconnection.open ("Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\db\kegler.mdb")) SQLQuery = "Select * from keglerstats;" set rs = Server.CreateObject("ADODB.Recordset") set rs = myconnection.Execute(SQLQuery) rs.movefirst str1990 = rs("Since1990") strlanes = rs("TotalLanes") strstates = rs("TotalStates") strcenters = rs("Centers") strtemppassword = rs("po_password") strtempuser = rs("po_username") set rs=Nothing If Request.Form.Count > 0 Then if Request.Form("po_username")="" then theusername="N/A" else theusername=Request.Form("po_username") if Request.Form("po_password")="" then thepassword="N/A" else thepassword=Request.Form("po_password") if theusername <> "N/A" then if UCase(theusername) = UCase(strtempuser) then if thepassword = strtemppassword then Session("loginokay") = True Response.Redirect "po_index.asp" else strdenied = "The password you entered did not match the username entered. Please try again." end if else strdenied = "The username entered is incorrect. Please try again." end if end if End If %>
|
|||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||