pb with escape char

Sylvain Le Gourriérec sylvain.legourrierec at son-video.com
Mon Sep 9 06:11:01 EDT 2002


I put the result of an SQL query into a variable.

the result is a string, for example : la "nouvelle" d'ici-bas.

put myResult into myVar

put "INSERT INTO myTable SET myField = '" & myVar & "'"

---> but MySQL get INSERT INTO myTable SET myField = 'la "nouvelle" d'

How can I preserve my quoted strings?

Is there a kind of addSlashes() function?


Sylvain Le Gourriérec  --  développement  -- son-video-distribution

-------------> windows 2000 + runrev 1.1.1 + MySQL 3.23 + PHP 4
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.runrev.com/pipermail/use-livecode/attachments/20020909/ed964a33/attachment.html>

More information about the Use-livecode mailing list