Brekeke SIP Server Wiki

Execute the SQL update
Note: $db.update method is available in the Advanced Edition only.

Syntax:

$db.update( db-name, sql )

Parameters:

db-name – database name defined at [Configuration] > [Advanced] page (Refer toExecute SQL query from Dialplan)
sql – an SQL statement

Returns:

true – if  the row count is more than 0.
false – otherwise

Version Since:

3.8

Example:

$db.update("mydb", "UPDATE table SET value='%2' WHERE key='%1'" ) = true

Execute UPDATE statement on the databse “mydb”.

See Also:

$db.query
Execute SQL query from Dialplan