一段找回用户密码的代码,请高手们看看问题出在哪?
找回密码<%if request("ok")<>"ok" then%>
<%else%>
<%end if%>
<%
if request("action")="" then response.end
'取的丢失密码帐户的EMAIL地址
set rs=server.createobject("adodb.recordset")
username=request("username")
Username=replace(Username,"'","")
sql="select * from user where username='"&username&"'"
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.redirect "error.asp?error=008"
end if
'设置发信人
frommail="aof@163.com"
'设置邮件主题
mailsubject="您在www.*****.com的密码!!!"
'设置邮件内容
mailbody="您的密码是 " & rs("password")
'判断对谁发信
tomail=rs("email")
'发
Set objCDOMail = Server.CreateObject("CDONTS.NewMail")
objCDOMail.From = frommail
objCDOMail.To = tomail
objCDOMail.Subject = mailsubject
objCDOMail.Body = mailbody
objCDOMail.Send
Set objCDOMail = Nothing
response.redirect "findpassword.asp?ok=ok"
%>