system.db. runPrepUpdate( query, args, [database], [tx], [getKey], [skipAudit] )
String query - A query (typically an UPDATE, INSERT, or DELETE) to run as a prepared statement with placeholders (?) denoting where the arguments go.
Object args - A list of arguments. Will be used in order to match each placeholder (?) found in the query.
String database - Optional, The name of the database connection to execute against. If omitted or "", the project's default database connection will be used.
String tx - Optional, A transaction identifier. If omitted, the update will be executed in its own transaction.
Boolean getKey - Optional, A flag indicating whether or not the result should be the number of rows returned (getKey=0) or the newly generated key value that was created as a result of the update (getKey=1). Not all databases support automatic retrieval of generated keys.
Boolean skipAudit - Optional, A flag which, if set to true, will cause the prep update to skip the audit system. Useful for some queries that have fields which won't fit into the audit log.
Integer - The number of rows affected by the query, or the key value that was generated, depending on the value of the getKey flag.