I have run into an issue where I have a field that may contain quotes(") does not build correctly when set as a type Select. Looking at the html source for the page, I get the following <option value=“P032294 -12” carton"="" -15"rail="">P032294 -12"-15"RAIL CARTON </option> and I would want the value to be P032294 -12" carton -15"rail and not appear to have carton and rail attributes. I receive an ‘Invalid data’ error after I select a value with a quote in it and move to a different field.
This field is driven off another field via the ‘Use AJAX…’ button. Is there someway to have the select input field built with something like htmlspecialchars() or addslashes() and then remove the special characters when saving?
Database is MSSQL with a linked server to a Progress database.