产生一个密码，并记录到数据库，然后发送给用户

this article generates a password random, requires a database and mails the password.

<%@language="vbscript" %>

******************************
<%
code by manikantan
web developer
3rd agenda
nungambakkam, chennai india
%>

<%

set mail= server.createobject("cdonts.newmail")
mail.subject="thank you for registering"
mail.to = mailid mail.from ="webmaster@thesite"
mail.body= "this is the initial password to our site...." & vbcrlf
&href=mailto:mailid="mailid="[e-mail]">[e-mail]>mailid="[e-mail]"
address="address"

other data like phone number as per the member database in the site
all these values are obtained from the request method from a .htm which submits to this file
mainly employed in registration
assumes you have cdonts.dll installed in the web server.

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)

an update query can be passed from here for the username ,password and other details or can be triggered
from another page when the user responds to the mail...something like sending a url as a mail and on
click of the url in the mail..call another page which updates ..so we can be sure that only confirmed
users are updated

%>
<br>
<%
set mail= server.createobject("cdonts.newmail")
mail.subject="thank you for registering"
mail.to = mailid
mail.from ="webmaster@thesite"
mail.body= "this is the initial password to our site...." & vbcrlf & "change it if you want" & vbcrlf &
pwd & vbcrlf & "thank you for using the site"
mail.send
%>