Please Enter Your Login ID:
SELECT strEmailAddress AS email FROM tblAdministrator,tblUserData WHERE tblUserData.userID=tblAdministrator.adminID AND tblUserData.loginId='#form.loginID#' UNION SELECT strAgentEmail AS email FROM tblAgentMaster,tblUserData WHERE tblUserData.userID=tblAgentMaster.agentIDPK AND tblUserData.loginId='#form.loginID#' UNION SELECT strSellerEmail AS email FROM tblCertificates WHERE tblCertificates.locID='#listfirst(form.loginID,'-')#' AND tblCertificates.seqID='#listfirst(form.loginID,'-')#' UPDATE tblUserData set passwordHash='#passhash#' WHERE loginID='#form.loginID#' The password for login ID #form.loginID# has been reset. The new password is #pass#. #message# Your password has been reset and sent to the email address #emailto#. Please check email and try your login again from the main page