select * from tusers where userid= SELECT UserID, Lname, Fname,username, Password, s2, LastLogin,company, ispublic, siteid,passwordCreated,subType FROM tusers WHERE username= AND Password= AND Type = 2 and inactive=0 SELECT UserID, Lname, Fname,username, Password, s2, LastLogin,company, ispublic, siteid,passwordCreated FROM tusers WHERE userid= AND Type = 2 and inactive=0 Select groupname, isPublic, siteid from tusers where userid in (Select GroupID from tusersmemb where userid='#rsuser.userid#') UPDATE tusers SET LastLogin = #createodbcdatetime(now())# WHERE tusers.UserID='#rsUser.UserID#' select userID, username,password,email,fname,lname from tusers where type=2 and inactive=0 and email= and ( (siteid='#variables.instance.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#' and isPublic=0) or (siteid='#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' and isPublic=1) ) and isPublic=0 ' ]+@[^@%*<>' ]{2,255}\.[^@%*<>' ]{2,5}", trim(arguments.email)) neq 0> #sendLoginScript# Dear #firstname#, You've requested your login information be sent to you. Username: #username# Password: #password# Please contact #contactEmail# if you have any questions or comments on this process. Thank you, The #contactName# staff