如何將產生的密碼記錄並發送給使用者並通過點選連結啟用？

<%@language="vbscript" %>
<%
set mail= server.CreateObject("cdonts.newmail")
mail.subject="恭喜,您在隨風起舞註冊成功,感謝您的參與!"
mail.to = mailid mail.from ="song@intels.net"
mail.body= "這是隨風起舞寄給您的初始密碼" & vbcrlf
&href='mailto:mailid="user@intels.net'>mailid="user@intels.net"
address="address"

set conn = server.CreateObject("adodb.connection")
conn.Open "dsn","uid","pwd"
set rec= conn.Execute("select count(*) from membertable")
id = cint(rec.fields(0))+1
r=rnd *50
Response.Write r & "<br>"
for i = 0 to 20
    if cint(r)>0 and cint(r)<26 then str=str +chr(97 + cint(r))
    r=rnd *100
next

Response.Write str
pwd=left(str,2)
pwd=pwd & id
pwd=pwd & right(str,2)
pwd=pwd & second(time)

%>
<br>
<%
set mail= server.CreateObject("cdonts.newmail")
mail.subject="千花飛舞向您問候!"
mail.to = mailid
mail.from ="song@intels.net"
mail.body= "這是隨風起舞寄給您的初始密碼" & vbcrlf & "您可以隨時修改它" & vbcrlf &
pwd & vbcrlf & "再次感謝光臨隨風起舞!"
mail.send
%>

 

[1]