sql:delete

sql:delete performs an SQL DELETE statement. This causes a set of rows to be selected from a given table and deleted.

The attributes are as follows:

connection

The database connection. This is mandatory, the value is an expression, which must evaluate to a database connection object as returned by sql:connect.

table

The table containing the rows to be deleted. This is mandatory, and the value must be known statically (it cannot be defined as an attribute value template).

where

The conditions to be applied (the contents of the WHERE clause of the select statement). This is optional, if present the value is an attribute value template whose value is a SQL conditional expression. If omitted, all rows in the table are deleted.