1 Reply Latest reply: Jun 27, 2013 8:42 PM by p.sim RSS

    Rereplace Apostrophes?


      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