rivet

BaseElement plugin : insert escape single quote

Discussion created by rivet on Dec 5, 2016
Latest reply on Dec 5, 2016 by rivet

I am trying to use the BaseElements function 'BE_FileMakerSQL' to insert a record but it doesn't seem to like an escaped single quote. Has anyone come across/solved this?

 

pass:

BE_FileMakerSQL ( "INSERT INTO thetable ( thefield ) VALUES ( 'Test' )" )

 

fail:

BE_FileMakerSQL ( "INSERT INTO thetable ( thefield ) VALUES ( 'Test\'s' )" )

Outcomes