UpdateData

Overview

Updates an existing row in a data extension for the specified number of columns used to build the where clause listed in name value pairs followed by a list of columns to be updated in name value pairs. Returns the number of rows affected. Use this function with landing pages and SMS messages only.

Syntax

UpdateData(1, 2, 3, 4, 5, 6)

Function Properties

OrdinalTypeDescription
1stringRequiredName of data extension from which to update the specified row
2numericRequiredNumber of columns used to build WHERE clause
3stringRequiredColumn name to build WHERE clause
4stringRequiredValue used to build WHERE clause
5stringRequiredColumn name to build INSERT clause
6stringRequiredValue used to build INSERT clause

Usage