pop_profile.asp

		'Update the user e-mail
		strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
		strSql = strSql & " SET M_EMAIL = '" & rsKey("M_NEWEMAIL") & "'"
		strSql = strSql & ", M_KEY = ''"
		strSql = strSql & " WHERE MEMBER_ID = " & userID

		'Update the user e-mail
		strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
		strSql = strSql & " SET M_EMAIL = '" & chkString(rsKey("M_NEWEMAIL"),"SQLString") & "'"
		strSql = strSql & ", M_KEY = ''"
		strSql = strSql & " WHERE MEMBER_ID = " & userID

Power - The only narcotic controlled by the SEC, not the FDA.

Prosperity without pollution! The American Hydrogen Association - http://www.ahanw.org
Questions about Hydrogen? Post them on our forum - http://www.ahanw.org/forum