469,934 Members | 2,346 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Sql Query when forgot password

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.
Oct 3 '07 #1
1 1672
jhardman
3,406 Expert 2GB
Peter,

this looks good so far. What part is giving you trouble?

Jared
Oct 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Ini | last post: by
2 posts views Thread by Francis Debrabandere | last post: by
5 posts views Thread by Mark | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.