<@NUMAFFECTED>

Description

Returns the number of database rows affected by the last Insert, Update, Delete, or DirectDBMS 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 DirectDBMS 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 DirectDBMS action is executed, the tag returns "-1".

Note:

• If the last DirectDBMS action performs a search, the tag also returns "-1".
• Some ODBC drivers do not support this meta tag. In these cases, the tag 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 how many changes were made:

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