New Posts New Posts RSS Feed: Rdbquery issue: string pattern '%[[[]]%' is invalid.
  FAQ FAQ  Forum Search Search  Calendar Calendar  Register Register  Login Login

Rdbquery issue: string pattern '%[[[]]%' is invalid.

 Post Reply Post Reply
Author
HFloyd View Drop Down
Groupie
Groupie


Joined: 27-Jul-2007
Location: United States
Posts: 44
Post Options Post Options   Quote HFloyd Quote  Post ReplyReply Direct Link To This Post Topic: Rdbquery issue: string pattern '%[[[]]%' is invalid.
    Posted: 03-Jul-2009 at 5:23pm
Hi,
I have found that if the string '[' is passed to an Rdbquery for searching, it gives an error:

System.Data.EvaluateException was unhandled
  Message="Error in Like operator: the string pattern '%[[[]]%' is invalid."


Is there some way I can escape that character when creating an Rdbquery so it doesn't throw the error? Are there any other charcters which might need to be handled when passed in to Rdbquery?

(This is a simple keyword search form in my app.)

Thanks!

Heather
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down