Search
⌃K
Links

queryConnection

To send a SQL command to a connected SQL database and returns the record data.
In case you want to send a command to a connected SQL database, use this function to send your command as a string through a specified connection.
In contrast to sendCommand() the result will contain the record data only and leave out the metadata.
Learn more about SQL connections.

Syntax

queryConnection(string, string)

Return

JSON

Examples

queryConnection(connectionName, command) To send a given SQL command to a connected SQL database by specifying the connection name.
1
do as server
2
formatJSON(quereyConnection("MySQLConnection", "SELECT 1"))
3
end
Result:
{result: [{"id":2,"name":"feature a","price":99.99,"created_at":"2021-06-02T08:00:00.000Z"}]}

See also

​sendCommand, sends a SQL command to a connected SQL database.
Last modified 1yr ago