<%
if request.form("submit") = "Login" then
sql = "select * from distributors where username = '" & request.form("username") & "' and password = '" & request.form("password") & "'"
set rs = conn.Execute(sql)
if rs.eof then
msg = "Login Failed!
"
else
response.redirect "home.asp"
end if
end if
%>