Mar 16th, 2015, 12:57 PM
I have - I believe - a similar problem with apostrophes and quotes in the textbox input but with different results.
I have built a form to enter data from the label of products. Amonst the fields there is one for the brand name. In some cases, that amy include apostrophes, single or double quotes.
Unlike what the other users described, in my case the input doesn't get truncated but, instead, a backslash ("\") is placed before the apostrophe or the quotation mark. I understand that this may be part of the string sanitation that formtools performs. However, each time that an entry with a field containing an apostrophe or quotation mark is updated, an extra backslash is added.
So, for instance, the (hypothetical) brand name "Smith's" would be displayed as "Smith\'s". After another update of the entry that would become "Smith\\\'s" (which makes sense since the backslash needs shielding, too). Another update will lead to "Smith\\\\\\\'s, an so on.
I have verified that the input is saved as such in the database.
Is there any way to address that?
Thanks in advance for your time!
PS I am using FormTools v.2.2.6 and my form is a "Form builder" one.
I have built a form to enter data from the label of products. Amonst the fields there is one for the brand name. In some cases, that amy include apostrophes, single or double quotes.
Unlike what the other users described, in my case the input doesn't get truncated but, instead, a backslash ("\") is placed before the apostrophe or the quotation mark. I understand that this may be part of the string sanitation that formtools performs. However, each time that an entry with a field containing an apostrophe or quotation mark is updated, an extra backslash is added.
So, for instance, the (hypothetical) brand name "Smith's" would be displayed as "Smith\'s". After another update of the entry that would become "Smith\\\'s" (which makes sense since the backslash needs shielding, too). Another update will lead to "Smith\\\\\\\'s, an so on.
I have verified that the input is saved as such in the database.
Is there any way to address that?
Thanks in advance for your time!
PS I am using FormTools v.2.2.6 and my form is a "Form builder" one.