<@NUMAFFECTED>

Description

Returns the number of database rows affected by the last Insert, Update, Delete, or Direct DBMS action executed. All other actions have no effect on what the tag returns. The value returned by the tag is always the number of rows affected by the last Insert, Update, Delete, or Direct DBMS action executed. This tag only works for Oracle and ODBC data source types. The tag has no attributes.

At the start of execution, and until an Insert, Update, Delete, or Direct DBMS action is executed, the tag returns "-1".

Note:

• If the last Direct DBMS action performed a search, the tag also returns "-1".
• For Mac OS, this tag works only with ODBC and OCI data sources. It does not work with FileMaker Pro and DAM data sources, and hence always returns "-1".
• Some ODBC drivers do not support this meta tag. For data sources using these drivers, the tag always returns "-1".

Example

An Update action in your application file updates a product code. In the Results HTML for that Update action, you could use <@NUMAFFECTED> to return to the user the number of records changed:

<P><STRONG><@NUMAFFECTED></STRONG> records were updated in the database.</P>