Print Page | Close Window

Rdbquery issue: string pattern '%[[[]]%' is invalid. Printed From: IdeaBlade Category: DevForce Forum Name: DevForce Classic Forum Discription: For .NET 2.0 URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1358 Printed Date: 27-Apr-2025 at 7:36am Topic: Rdbquery issue: string pattern '%[[[]]%' is invalid. Posted By: HFloyd Subject: Rdbquery issue: string pattern '%[[[]]%' is invalid. Date 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

Print Page | Close Window