2 Replies Latest reply on Feb 13, 2014 9:35 AM by Steve Sommers

    CKeditor and cfm

    Paul1 Level 1

      This is probaly a begineers question so apologies if it is a bit basic. It could also be a MySql fix rather than Colfusion!



      I have a textarea field on a web form using the popular text editor ckeditor.


      The form is posted to a Coldfusion page and the data is added to a MySQl database.


      This works fine until someone adds a " in their text input. This being the escape character an error is generated!




      <cfquery name="insert" datasource="text_test">

      insert into TEXT (TEXT1, TEXT2) values ("#Form.text1#", "#Form.text2#");





      Any theories on how I can get round this would be gratefully apreciated.


      Many thanks,