Ciao Paolo, ben ritornato

Posto qui tutto lo script completo:
<%
%>
<!--#include file="inc/common.asp"-->
<!--#include file="inc/mailobject.asp"-->
<%
strMailSubject = "Your New Account"
Dim name, email, password, address, town, zipcode, country
name=(trim(request.form("Name")))
email=(trim(request.form("email")))
password=(trim(request.form("ConfirmPassword")))
If password = "" Then
Session("msg") = ("Please enter a password")
response.redirect ("register.asp")
End If
address=(trim(request.form("address")))
town=(trim(request.form("town")))
country=(trim(request.form("country")))
If request.form("subscribe") = "true" then
mlist_option = "yes"
Else
mlist_option ="no"
End If
ConnectMembersDB()
connectrst()
strSQL = "SELECT * FROM [memberlist] WHERE = '" & email & "' "
'Check new email is already registered or not
adorst.Open strSQL, adocon, 3, 3
If Not adorst.BOF AND Not adorst.EOF Then
Session("msg") = ("Email ID: "& " " & "<b>" & email & "</b>" & " is already registered.")
response.redirect("register.asp")
'If new email address then allow to register
Else
adorst.AddNew
adorst.Fields("name") = ChkString(name)
adorst.Fields("email") = ChkString(email)
adorst.Fields("pass") = ChkString(password)
adorst.Fields("address") = ChkString(address)
adorst.Fields("town") = ChkString(town)
adorst.Fields("country") = country
adorst.Fields("signupdate") = date
adorst.Fields("ip") = Request.ServerVariables("REMOTE_ADDR")
adorst.Fields("subscribe") = mlist_option
adorst.Fields("active") = "no"
adorst.Update
adorst.MoveFirst
End If
adorst.Close
Set adorst = Nothing
'Fatch the newly registered user ID
Set rstGetNewUserInfo = Server.CreateObject("ADODB.Recordset")
rstGetNewUserInf

pen "SELECT * FROM [memberlist] WHERE [email] = '"& email & "'", adocon, 1, 1
intNewUserID = rstGetNewUserInfo("id")
strNewUserEmail = rstGetNewUserInfo("email")
strNewUserName = rstGetNewUserInfo("name")
strNewUserPass = rstGetNewUserInfo("pass")
rstGetNewUserInfo.Close
Set rstGetNewUserInfo = Nothing
adocon.Close
set adocon = Nothing
'Create Email Body
MailBody= ("Ciao" & " " & strNewUserName & vbcrlf & vbcrlf _
& "<p>Grazie per esserti registrato con noi. I tuoi dati di accesso nell'area riservata sono i seguenti:" & vbcrlf _
& "<p>Username: " & strNewUserEmail & vbcrlf _
& "<br>Password: " & strNewUserPass & vbcrlf _
& "<p>Per confermare l'attivazione e utilizzare il tuo accounttivation link below." & vbcrlf _
& "<p>Activation Link: " & "<a href=" & strSiteURL & "/" & strFolderName & "/activate.asp?atvId=" & intNewUserID & "&email=" & strNewUserEmail & ">" & _
strSiteURL & "/" & strFolderName & "/activate.asp?atvId=" & intNewUserID & "&email=" & strNewUserEmail & "</a>." & vbcrlf & vbcrlf _
& "<p>Warmest Regards,<br>" & vbcrlf _
& strSiteName & "<br>" & vbcrlf _
& strSiteURL & vbcrlf _
& vbcrlf _
& "<p>------------------End of Message----------------" )
strToEmail = strNewUserEmail
strFromEmail = strAdminEmail
strSubject = strMailSubject
strEmailBody = MailBody
Call SendMail(strToEmail, strFromEmail, strSubject, strEmailBody)
Session("msg") = "Congratulation!" & "<br>" & " You account is successfully created. An email containing activation link is on the way to your email.<br> Please check your email and activate your account."
response.redirect("result.asp")
%>