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}}}
However, this is extremely susceptible to SQL injection.
You would be far better off using Prepared Queries
See the read me for how to
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.