Re: escaping character in sql statements

Mark Mchugh wrote:
> hi,
> i need double the number of them cos in the database the file/path
> name is stored as
>
> \\192.168.0.100\clients\\o''orielly\file1.pdf
>
> wierd?
>
Oh sorry, in this case you must write it as
select * from files where location = 
'\\\\192.168.0.100\\clients\\\\o\'\'orielly\\file1.pdf'
In other word, you must quote this way
char(s)    quoted
--------------------------
\                    \\
\\                   \\\\
'                    \'
''                    \'\'

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail 
from another non-spammer site please.)



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]