MSSQL node msg reading

[noob69]

Hi,

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('{{{msg.email}}}','time',1,10)

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

What is causing this?

[Steve-Mcl]

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.

[noob69]

Thanks a lot, Nice explanation