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%'

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

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