PDA

View Full Version : How can I do a confirmation email for a database?


ashur
08-04-03, 05:41 PM
Hello :)
My first post in here. I really need your help guys. I have created a database in FrontPage 2002. It gathers the information colected from a user from a form and displays them in an HTML table.

Problem is, I don't want the information to be displayed right away. I want an email to be sent to them. Only when they click on that email will their info be posted online. This is to guard against spam. After all the database is a list of MSN users. So I don't want someone coming in and registering someone else's email without their consent.

If you are willing to help, I would greatly appreciate it. I can show you the source code or whatever else you need to help me with this.

Thank You,
Ashur

BuildHome
08-05-03, 08:50 PM
Hi,

You need CDONTS support on your server to do that.
Is It ACCESS database ?

I can help you If you will show me the code.
You can also learn about CDONTS, It's very easy.

If you don't have CDONTS support, you can do It by make them click on a button that will activate there profile.

MadDog
08-05-03, 10:42 PM
Its really simple,

You have a sign up form, after the user fills it all out you need to add thats users information to a database, then send out an email with a link that has some kind of user ID in it (example, the link being, www.mysite.com/verify.asp?UserID=1123232). They click the link that has the user ID in the querystring, on the page they click to go to you need to make it so that ID searches there user ID in the database, and if found make users account active.

Its pretty simple ;)