Hi all,
I need to do a checking whether the SQL query was successful or failed in an if else statement for both MySQL (msg.topic) and MSSQL (msg.payload).
For example:
msg.topic = "UPDATE test SET name='Login' WHERE id='123'";
if ( /* Condition to indicate that the query is successful */ ) {
msg.payload = "Query was successful";
}
else {
msg.payload = "Query failed";
}
Tagging @knolleary and @thiren for this topic discussion.