 | | | Subject: Re: escaping character in sql statements | Subject: Re: escaping character in sql statements 2007-10-25 - By Mark Mchugh
Back
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 <todd@(protected)>
To: Mark Mchugh <mark_mch@(protected)>
Cc: Petr Vileta <petr@(protected)>; mysql list <win32@(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/win32?unsub=mysql@(protected)
|
|
|