sql:update
Performs an SQL UPDATE
statement. This causes a set of rows to be
selected from a given table; columns identified in a child sql:column element are then updated
with new values.
Attributes
|
|
The database connection. The value is an expression, which must evaluate to a database connection object as returned by sql:connect. |
|
|
The table to be updated. The value must be known statically (it cannot be defined as an attribute value template). |
|
|
The conditions to be applied (the contents of the |
Details
An sql:column
may be used as a child element of
sql:update
, to identify the name and value of a column to be
included in the UPDATE
statement. The name of the column is
identified by the name
attribute, the value may be indicated either
by evaluating the expression contained in the select
attribute, or as
the expanded contents of the sql:column
element. The value is converted to
the required data type (the declared type of the column) if possible.