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

Rdbquery issue: string pattern '%[[[]]%' is invalid.
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
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