How to insert raw data into the database?

The nodes in the screenshot record the user's message and save it to the mysql table.
But, if the user enters text with quotation marks (""), they get to the database as '& quot;'
How do I insert raw data into the database?


Read the built in help for the template node.

It says to use triple braces

{{{payload}}}
1 Like

However, this is extremely susceptible to SQL injection.

You would be far better off using Prepared Queries

See the read me for how to

1 Like

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