Get the Error that my e-mail addresses are not the same when I register a new user. I've cut and pasted the exact same one along with typing it VERY carefully. I've confirmed my register.asp with the one enclosed in the ZIP, yet I still get the same error. Any tips?
Any chance the following lines are causing the error? However, this matches the register.asp for the ZIP.
if strUniqueEmail = "1" then
'## Forum_SQL
strSql = "SELECT M_EMAIL FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_EMAIL = '" & Trim(Request.Form("Email")) &"'"
set rs = my_Conn.Execute (strSql)
if rs.BOF and rs.EOF then
'## Do Nothing
else
Err_Msg = Err_Msg & "<li>Email Address already in use, Please Choose Another</li>"
end if
rs.close
set rs = nothing
'####################### Email Validation Mod ################################
if lcase(strEmail) = "1" and strEmailVal = "1" then
'## Forum_SQL
strSql = "SELECT M_EMAIL FROM " & strMemberTablePrefix & "MEMBERS_PENDING "
strSql = strSql & " WHERE M_EMAIL = '" & Trim(Request.Form("Email")) & "'"
set rs = my_Conn.Execute (strSql)
if rs.BOF and rs.EOF then
'## Do Nothing
else
Err_Msg = Err_Msg & "<li>E-mail Address already in use, Please Choose Another</li>"
end if
rs.close
set rs = nothing
end if
'#############################################################################
Topic Locked
Posted - 15 April 2002 : 08:44:22
