[Mono-devel-list] RowFilter, Select expression, DataTable.GetErrors() bugs?

tsureshkumar tsureshkumar at novell.com
Tue Aug 2 08:14:16 EDT 2005


bandito wrote:
> Hello all.
> 
> I'm using mono 1.1.8.2 and the MySql connector (1.0.4.20163)
> 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.
> 

this part of the problem is just now fixed in svn.

> Next, I perform an update using MySqlDataAdapter.Update method. 
> After the update is completed, DataTable.GetErrors() returns all rows
> as erroneous.
> Yet, I can see in the database that all records have been updated
> successfully (except from one, which i'm trying to track down, but I
> cant :) ).
> I'm wondering if anyone else has encoutered any of these problems, Mr.
> Google knows nothing of it.

please file a bug for this with the exact stack trace, sample code and 
possibly a table dump to reproduce the problem.

suresh

> 
> Thanks in Advance
> George Chatzigeorgiou
> 
> P.S Development platform is a linux box, if it makes any difference.
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list



More information about the Mono-devel-list mailing list