set adoProc = server.createObject("ADODB.Command") adoProc.activeConnection = ado adoProc.commandText = "sp_updateAdminUserDetails" adoProc.commandType = adCmdStoredProc adoProc.parameters.refresh adoProc.parameters("@idAdmin") = idAdmin adoProc.parameters("@uname") = request.form("uname") adoProc.parameters("@fname") = request.form("fname") adoProc.parameters("@mname") = request.form("mname") adoProc.parameters("@lname") = request.form("lname") adoProc.parameters("@email") = request.form("email") adoProc.parameters("@phone") = request.form("phone") adoProc.parameters("@address") = request.form("address") adoProc.parameters("@address2") = request.form("address2") adoProc.parameters("@city") = request.form("city") adoProc.parameters("@idState") = request.form("idState") adoProc.parameters("@zip") = request.form("zip") adoProc.execute , , adExecuteNoRecords set adoProc = nothing