Re: escaping character in sql statements

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?


----- Original Message ----
From: Todd Farmer <[email protected]>
To: Mark Mchugh <[email protected]>
Cc: Petr Vileta <[email protected]>; mysql list <[email protected]>
Sent: Thursday, October 25, 2007 10:55:43 AM
Subject: Re: escaping character in sql statements


Mark Mchugh wrote:
> for some reason this does not seem to work either?

I think Petr's comment is correct, but perhaps there are other reasons 
this is not working the way you expect.  It seems like you have double 
the number of backslashes you need:

mysql> select
 '\\\\\\\\192.168.0.100\\\\clients\\\\o''orielly\\\\file%';
+----------------------------------------------+
| \\\\192.168.0.100\\clients\\o'orielly\\file% |
+----------------------------------------------+
| \\\\192.168.0.100\\clients\\o'orielly\\file% |
+----------------------------------------------+
1 row in set (0.00 sec)

You might try this format instead:

mysql> select '\\\\192.168.0.100\\clients\\o''orielly\\file%';
+-----------------------------------------+
| \\192.168.0.100\clients\o'orielly\file% |
+-----------------------------------------+
| \\192.168.0.100\clients\o'orielly\file% |
+-----------------------------------------+
1 row in set (0.00 sec)

Is that more like what you are hoping to match?


-- 
Todd Farmer





__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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