http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Rdbquery issue: string pattern '%[[[]]%' is invalid. Sat, 11 Apr 2026 23:07:06 -700 Fri, 03 Jul 2009 17:23:23 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1358 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1358&PID=4895#4895 Author: HFloyd
Subject: 1358
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
]]> Fri, 03 Jul 2009 17:23:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1358&PID=4895#4895