SqlQuery Nonquery Example
When performing insert or update statements, the query yields no actual result. In this case you can use mode="nonquery" to indicate that the query will not yield a result. For update statements, the affected number of records is returned.
| Smartsite SXML |
Copy Code
|
|---|---|
<se:sqlquery
mode="nonquery"
sql="update contents set Author='Dan Brown' where nr=19767"
/>
|
|
| Example Result |
Copy Code
|
|---|---|
1 |
|