pb with escape char

[Sylvain Le Gourriérec]

hello,

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?

thanks



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.htm>