MSSQL node msg reading


I need to add a value to a table. So I've created MSSQL node and input my msg as following.

INSERT INTO alert(email,alert,status,interval) VALUES('{{{}}}','time',1,10)

But it output a blank instead of the value of I have checked the output by intiating a debug node as It gives the correct output.

What is causing this?

To avoid issues like quotes in the string or SQL injection, you should use parameters...

Also, double check the msg going into the SQL node by setting the debug node to show complete message.

Thanks a lot, Nice explanation

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.