% if request.Form("formsub") = "strval" then adors1.open "Select * from beamemberTbl where Memail='"& request.Form("txtEmail") &"'", adoCon,2,3 if adors1.eof then adors1.addnew adors1("Mname") = request.Form("txtFName") adors1("Mic") = request.Form("txtICNo") adors1("Mdob") = request.Form("txtDOB") adors1("MhseAdd") = request.Form("txtHMadd") if request.Form("txtHMpcode")<>"" then adors1("MhsePostcode") = request.Form("txtHMpcode") end if adors1("MoffAdd") = request.Form("txtOFadd") if request.Form("txtOFpcode")<>"" then adors1("MoffPostcode") = request.Form("txtOFpcode") end if adors1("Mphonenum") = request.Form("txtPNum") adors1("Mfaxnum") = request.Form("txtFNum") adors1("Mmobile") = request.Form("txtMNum") adors1("Moccupation") = request.Form("txtOccu") adors1("Memail") = request.Form("txtEmail") adors1.update response.Redirect("beamember.asp?msg=1") else response.Redirect("beamember.asp?msg=0") end if adors1.close end if %>