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/win32?unsub=lists@pantek.com