|
Account Access
|
<%
Dim LaunConn
Dim CookCartID
Dim objFSO
Set LaunConn=Server.CreateObject("ADODB.Connection")
LaunConn.Open "DSN=LaundryCarts;"
CookCartID = Session("CookCartID")
CustID = Session("CustID")
%>
<%
If Request.Form("Login") <> "" Then
strSQL = "SELECT CustomerID, BFirstName FROM Customer WHERE Email LIKE '" & Request.Form("email") & "' AND Password LIKE '" & Request.Form("Password") & "'"
Set LaunDB = LaunConn.Execute(strSQL)
If NOT LaunDB.EOF Then
CustID = LaunDB("CustomerID")
Session("CustID")=CustID
LaunDB.Close
Set LaunDB = Nothing
Else
Response.Write "Incorrect Login"
End If
End If
If CustID <> "" Then
strSQL = "SELECT CustomerID, BFirstName, seclvl FROM Customer WHERE CustomerID LIKE '" & CustID & "'"
Set LaunDB = LaunConn.Execute(strSQL)
Name = LaunDB("BFirstName")
Level = LaunDB("seclvl")
Session("Level") = Level
%>
<% Response.write "Welcome, " & LaunDB("bfirstname") & ", please select one of these options.
"%>
<%
Else
LaunConn.Close
Set LaunConn = Nothing
If CustID = "" Then
%>
<%
End If
End If
%>
|
|
|
|
|