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 |
|
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. |