Re: escaping character in sql statements

sorry, thats a typo, its the more traditional spelling....

• Original Message ---- From: Lawson Cronlund <lawson@vrtinc.com> To: Mark Mchugh <mark_mch@yahoo.com>; mysql list <win32@lists.mysql.com> Sent: Thursday, October 25, 2007 4:36:53 PM Subject: RE: escaping character in sql statements

Just a naïve question. Was your query to find a client of o'oreilly  (as
shown) or o'reilly (a more traditional spelling)?

Regards,

Lawson Cronlund
lawson@vrtinc.com
+1(480)308-0641 (voice)
+1(602)996-0376 (fax)
 

-----Original Message-----
From: Mark Mchugh [mailto:mark_mch@yahoo.com] Sent: Wednesday, October 24, 2007 12:50 PM To: mysql list
Subject: escaping character in sql statements

Hi,
I am writing an sql to retrieve data relating to certain files in a  folder
from my database. Some times part of the data may contain a '  character.

here's an example of the sql

select * from files where location =
'\\\\\\\\192.168.0.100\\\\clients\\\\o''orielly\\\\file%'

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

this recults returns no records from my database, even though there are records there. the records are path + file names, thats why i have to  use
the \ charater to escape them, this does not seem to like me using ' to escape the ' character, any ideas?

-- 
MySQL Windows Mailing List
For list archives: 
http://lists.mysql.com/win32
To unsubscribe:    
http://lists.mysql.com/win32?unsub=lawson@vrtinc.com


--
MySQL Windows Mailing List
For list archives: 
http://lists.mysql.com/win32
To unsubscribe:  
  
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com





__________________________________________________
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=lists@pantek.com