[Mono-bugs] [Bug 75686][Min] New - DataTable.Select does not do escaping for '.

bugzilla-daemon at bugzilla.ximian.com bugzilla-daemon at bugzilla.ximian.com
Tue Aug 2 08:31:22 EDT 2005

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by tsureshkumar at novell.com.


--- shadow/75686	2005-08-02 08:31:22.000000000 -0400
+++ shadow/75686.tmp.16016	2005-08-02 08:31:22.000000000 -0400
@@ -0,0 +1,27 @@
+Bug#: 75686
+Product: Mono: Class Libraries
+Version: 1.0
+OS Details: 
+Status: NEW   
+Priority: Minor
+Component: Sys.Data
+AssignedTo: tsureshkumar at novell.com                            
+ReportedBy: tsureshkumar at novell.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+Summary: DataTable.Select does not do escaping for '.
+pasted from mail from banditaras at gmail.com
+I'm using mono and the MySql connector (
+First, I'm having this problem with the RowFilter expression. 
+I want to do a DataTable.Select(someFilterHere), but if the filter
+contains a single quote, I cannot escape it. For example
+string filter = "ProductTitle = 'aa''aa'"; //invalid expression
+string filter = "ProductTitle = 'aa\\'aa'"; //invalid expression
+string filter = @"ProductTitle = 'aa\'aa'"; //invalid expression
+The first expression works fine in .Net.

More information about the mono-bugs mailing list