%@ Language="VBScript" %> <% On error resume next Public rsSubscriber Public SubscriberNo Public cnDB Session("WorkDir") = Server.MapPath("\FamilyMed") Session("dbConnection") = "Provider=Microsoft.Jet.OLEDB.3.51;" & _ "User ID=Admin;" & _ "Data Source=" & Server.MapPath("\FamilyMed") & "\Db\FamMedData.mdb" Session("dbConnectionMsg") = "Provider=Microsoft.Jet.OLEDB.3.51;" & _ "User ID=Admin;" & _ "Data Source=" & Server.MapPath("\FamilyMed") & "\Db\FamMedMsg.mdb" Session("ScubscriberID") = 0 Err.Clear '-- Buttons If Request.Form("btnContact") = "Contact Us" then Response.Redirect "Messages.asp" End if If Request.Form("btnSubmit") = "Submit" then If Len(Request.Form("SubscriberNo")) = 0 then Session("ErrMsg") = "" Else SubscriberNo = GetID(Request.Form("SubscriberNo")) If SubscriberNo <> 0 then Set cnDB = CreateObject("ADODB.Connection") cnDB.ConnectionString = Session("dbConnection") cnDB.Open If Err.number = 0 then Set rsSubscriber = cnDB.Execute("SELECT" & _ " tblSubscriber_Login.SubscriberNo," & _ " tblSubscriber_Login.SubscriberID," & _ " tblSubscriber.FamilyID," & _ " tblSubscriber_Family.PassWord," & _ " tblSubscriber_Login.Locked," & _ " tblSubscriber_Login.Deleted" & _ " FROM (tblSubscriber_Family" & _ " LEFT JOIN tblSubscriber ON" & _ " tblSubscriber_Family.FamilyID = tblSubscriber.FamilyID)" & _ " LEFT JOIN tblSubscriber_Login ON" & _ " tblSubscriber.SubscriberID = tblSubscriber_Login.SubscriberID" & _ " WHERE tblSubscriber_Login.SubscriberNo=" & SubscriberNo & ";") If rsSubscriber.eof then Session("ErrMsg") = "Invalid Login" ElseIf rsSubscriber("Deleted") = vbYes then Session("ErrMsg") = "Invalid Login" ElseIf rsSubscriber("Locked") = vbYes then _ Session("ErrMsg") = "Please contact Family Medical" ElseIf rsSubscriber("PassWord")<> Request.Form("PASSWORD") then Session("ErrMsg") = "Invalid Login" else Session("SubscriberID") = rsSubscriber("SubscriberID") Session("FamilyID") = rsSubscriber("FamilyID") rsSubscriber.Close Set cnDB = Nothing Response.Redirect "Subscriber.asp" End if Else Session("ErrMsg") = "Invalid Login" End if rsSubscriber.close set cnDB = Nothing End if End if End if %>
" Response.Write "Error: " & Session("ErrMsg")& "
" Session("ErrMsg") = "" End if %>