hi
i have a site that people have to register to use, it's all running smoothly but what i want to do now is implement a double opt-in system which would serve two purposes.. firstly it would make sure the email they submit is valid (if it isnt they wont get the mail) and secondly it would ensure that they have signed up and not somebody else using their email address.
I have it set up now to send an email with their username etc when they sign up but how can i send an email with a link that they have to click on to confirm they really signed up??
I'm sure youve all seen this type of thing but i've no idea how to set it up.
any help greatly appreciated

Dave

ASP/VBScript/IIS5.1/WinXPPro & WinXPHome

what are you using to send the email to them?

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

Hi Dave

I use this all the time in sites that I build. I purchased a 'Starter Kit' from www.ultradevextensions.com/starterkit2/ This has loads of great stuff and only costs £20.

Cheers

Perry

....It's only easy if you know the answer

ooops sorry vince, i'm using jmail

thanks perry, will check it out.

ASP/VBScript/IIS5.1/WinXPPro & WinXPHome

here swhat i've done so far

I've amended the email that goes out to new users to include a link back to
the sites validatenewmember page, and this page contains a recordset filtered by emailaddress from the members table

www.thesitename.co.uk/validatemember?emailadd=theemailaddress

I was then thinking of putting a form on the page with hidden a hidden field that updates the table to show the user has confirmed their membership.
However how can i restrict access to this page? so that someone cant just type in the url and get to the page. I cant use the restrict access behaviour because that relies on people being logged in, and if the real user clicks the link in their email then they are not logged in but i need them to be able to access the page.

mmmmmmmm

Dave



ASP/VBScript/IIS5.1/WinXPPro & WinXPHome

ok

I've changed the link back to the confirmation page to include username,email and password.
On the confirmation page there is a recordset filtered by these URL parameters.
So far so good.
also on the confirmation page i have included this code that seems to work, redirecting if the recordset is empty

<b>&lt;%If rsetConfirm.EOF And rsetConfirm.BOF Then %&gt;
&lt;% Response.Redirect("home.asp" %&gt;
&lt;%End If %&gt;</b>

so this prevents someone just typing in the page url.

There is a form on the page with a hidden field which updates the user from Guest to Member when they hit the submit button.

I have also made an admin page with a recordset that displays users that have joined (more than two weeks ago) but not confirmed, so i can simply delete them if they havent confirmed within that time period, this is the sql for that recordset
<b>
SELECT *
FROM accessgroups
WHERE ((accessgroups.fldjoined&lt;Date()-14)) AND fldGroup = 'Guest'
ORDER BY fldjoined DESC
</b>

What i need to do now is to make the confirmation form submit automatically without the user having to press a button.
Also need to figure out a way to delete the users who havent confirmed after 2 weeks automatically.
Ideas please!!!!!!

ASP|VBScript|IIS5.1|WinXPPro & WinXPHome