Page Comparison

Overview

...

number $Database.ExecuteNonQuery(connectionName: string, query: string, timeout: number, parameters: object)

string connectionName

name of external database name

string query

query to be run

number timeout

request timeout. Optional.

object parameters

parameters set on the query. Optional.

CONNECTION_NAME can be set on Edit Domain → URL Credentials → External Database Credentials.

Code Block

language	js

$Database.ExecuteNonQuery("CONNECTION_NAMEAppDB", "updatedelete wDomainsUsers setwhere StatusId = 1 where Id=@Id", 100, {
    Id: id"1"
});