Run custom SQL UPDATE/DELETE for modifications

Executes a raw SQL UPDATE or DELETE statement. Use this for custom modifications not covered by the typed modifier functions.

For parameterized queries (safer, prevents SQL injection), use db_art_execute() instead.

Usage

db_art_update(statement, cn = NULL)

Arguments

statement

Character. SQL UPDATE or DELETE statement. Use parameterized queries or DBI::dbQuoteLiteral() to prevent SQL injection.

cn

Database connection. If NULL, creates a connection via artcore::dbc() and closes it on exit. Pass an existing connection to batch multiple queries efficiently.

Value

TRUE on success (statement executed, result cleared)

See also

db_art_execute() for parameterized queries

Other db-interface: db_art_append(), db_art_execute(), db_art_get()