Mine

		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