Hello,
We are experiencing problems with customers getting banned from our website when they enter their delivery address.
The problem is the single quote character e.g.: Plaine d'Areuse
Currently i can think of 2 workarounds but both are not satisfactory.
1: Management Center --> Web and HTTP --> Security --> SQL injection Check --> Add problematic fields to allow users to use the single quote character
This will probably cause problems because I don't know if DynamicWeb uses Parameters when executing queries.
2: Before submitting, html encode the single quote character (and other characters like < > & ")
The problem with this is that we want the single quote to be stored as a single quote and not as "'"
Thank you for your time and effort
Regards,
Dennis