Hello all respective fellows, i have a assignment where i need to create website that allow customer to order online with theusername and password.
My situation is when user forgot the password, then he may click request password.
Then, i need to compare the username enter by the user and the database and send his password through email.
This is what i have done so far.
<html>
<body>
set conn=Server.CreateObject("ADODB.connection")
conn provider="Microsoft.Jet.OLEDB.4.0"
conn.open "C:\Documents and Settings\tp012654\Desktop\mcdonald\member_database .mdb"
select if username==vsername from registerstep1
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Password Recover"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.TextBody="This is a message."
myMail.Send
set myMail=nothing
%>
</body>
</html>
I hope you can help me.
Your help is greatly appreciated by me and others.