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. queryConnection(string, string)
JSON
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"}]}
Last modified 7mo ago