1 Reply Latest reply on Oct 24, 2012 2:57 PM by Mike_Mitchell

    From Web Form to FileMaker Database: Odd Characters, PHP

    jcisco

      I hope you can help us with this, as it's causing a lot of problems!

       

      We have a webform that sends information to our database. But we often get bounce-backs (rejected by FileMaker). These bounce backs are often a result of odd characters (e.g., " There is however no ‘correct’ means by which a theory or research should be applied - these are all left up to the student making the interpretation and analysis").

       

      We had guessed that these were most likely the result of people pasting from Word (or some other text editor). Thus, we created editing buttoms above each field. This, however, caused an additional problem. With those, our FileMaker database was showing html coding (or something similar (e.g., "There is however no &lsquo;correct&rsquo; means by which a </em>theory <em> or research should be applied - these are all left up to the student making the interpretation and analysis.</p>"

       

      We're using web forms developed in php that submit to FileMaker Server using fx.php. The problem seems to stem from people copying and posting text from MS Word files. The text contains ANSI characters that we think FileMaker is not accepting, and therefore, causing the submission to trigger a FileMaker error code 958.

       

      What can we possibly do to fix this issue? Can FileMaker 11's database read HTML (i.e., can we change a setting?).

      Here's hoping someone out there can help us out!

       

      All the best,

      Jonathan

       

      Our webform without the editing buttons and a shot of our database itself (note the html/php):