[Mono-dev] Invalid escape selecting table rows

APS subscription.sapi at apsystems.it
Thu Jun 8 11:37:50 EDT 2006


Hi guys,
I've a datatable containing a list of urls.
I select them using

Tables[0].Select("(PAGE='\wsngmono\Categ.aspx' OR 
PAGE='/wsngmono/Categ.aspx') AND (CONTROL='' OR CONTROL IS NULL) AND 
ENABLED=0")

and I obtain this error:

System.Data.SyntaxErrorException: Invalid escape sequence: '\s'.
in <0x00118> Mono.Data.SqlExpressions.Tokenizer:ProcessEscapes (Char c)
in <0x000cc> Mono.Data.SqlExpressions.Tokenizer:ReadString (Char 
terminator, Boolean canEscape)
in <0x0015b> Mono.Data.SqlExpressions.Tokenizer:ParseToken ()
in <0x00030> Mono.Data.SqlExpressions.Tokenizer:advance ()
in <0x00274> Mono.Data.SqlExpressions.Parser:yyparse (yyInput yyLex)
in <0x00112> Mono.Data.SqlExpressions.Parser:Compile (System.String sqlExpr)
in <0x000dd> System.Data.DataTable:Select (System.String 
filterExpression, System.String sort, DataViewRowState recordStates)
in <0x00014> System.Data.DataTable:Select (System.String filterExpression)

Apparently there's no escape sequence in the query, I'm doing something wrong?




More information about the Mono-devel-list mailing list