[FX.php List] Bad apostrophe character confounds FMP

[Jonathan Schwartz]

Hi Folks,

I spent a bunch of time diagnosing a 958 error that was eventually 
narrowed down to a character in the name "O'Doherty".  The 
application loads an existing FMP record into a session, allows 
editing and then creates a new record based on the eited data.  The 
apostrophe appeared as "%92" in the FMP query, and caused the 958 
error during new record creation..  I have no idea how 958 relates, 
but it was definitely the culprit.

The question is, what techniques do you us to condition data,  a 
regexp? and on every field?

Thx.

Jonathan

-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-381-1852