First off let me preface this with I'm new to programming in general.
I'm working with coldfusion 10 and an access database
The problem I am having is regarding a certain form, people that use this web app like to copy and paste into the form fields and sometimes when they paste apostrophes they insert into the database as |-
Now its not really a problem until they attempt to open up the form they submitted and it pulls these fields with the strange character, thats when it takes a crap.
For the time being i just replace the strange characters with apostrophes in the database and everything is good to go.
I have been reading up on rereplace and I'm wondering if that would be the best solution
Any help would be greatly appreciated
Check PreserveSingleQuotes() and HTMLEditFormat().