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

Ordinal Type Description
1 string Required Name of data extension from which to update the specified row
2 numeric Required Number of columns used to build WHERE clause
3 string Required Column name to build WHERE clause
4 string Required Value used to build WHERE clause
5 string Required Column name to build INSERT clause
6 string Required Value used to build INSERT clause

Usage

UpdateData('SendDE',1,'_SubscriberKey',_SubscriberKey,'DateSent',NOW())
Last Updated: Jun 8, 2021