468,104 Members | 1,360 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,104 developers. It's quick & easy.

Escape characters going into MySQL from FileMaker

I'm trying to use an SQL plug-in to synch. FileMaker (FM) with a MySQL
DB. All is going great EXCEPT my FM text fields. If I have any special
characters in my FM text field, they foul-up the INSERT/UPDATE query
and produce an error.

For example, in the following sentence in the FM field:

I'm happy!

The information needs to go into the MySQL column as:

I\'m happy!

The \ "escapes" out the ' so that it doesn't foul up the SQL. I'm
aware of the substitute function in FM, but there are many characters
that have to be escaped and using that function seems cumbersome to do
so. In PHP there's a function called addslashes that will take care of
this for you. Does anyone know of a similar function or method within
FM? Likewise, I can also call MySQL functions, however I'm restricted
to those available in MySQL 3.23.43.

Jul 19 '05 #1
0 2676

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Guadala Harry | last post: by
1 post views Thread by el chupacabra | last post: by
15 posts views Thread by pkaeowic | last post: by
3 posts views Thread by qilin | last post: by
2 posts views Thread by sklett | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.