Server Error in '/' Application.

Error in Like operator: the string pattern 'shop/Sale - Up to 55% Off/Nightwear Sale Up to 50% Off%' is invalid.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.EvaluateException: Error in Like operator: the string pattern 'shop/Sale - Up to 55% Off/Nightwear Sale Up to 50% Off%' is invalid.

Source Error:


Line 101:        Dim Coll As XmlNode = Nothing
Line 102:
Line 103:        For Each dr As DataRow In Products.Select("Path LIKE '" & Node.Key.Replace("'", "''") & "%'")
Line 104:            If Coll Is Nothing Then Coll = Construct.CreateElement("nodes")
Line 105:

Source File: D:\Sites\NiceSurprises\www\Sitemap.aspx.vb    Line: 103

Stack Trace:


[EvaluateException: Error in Like operator: the string pattern 'shop/Sale - Up to 55% Off/Nightwear Sale Up to 50% Off%' is invalid.]
   System.Data.LikeNode.AnalizePattern(String pat) +1245751
   System.Data.LikeNode.Eval(DataRow row, DataRowVersion version) +353
   System.Data.Select.AcceptRecord(Int32 record) +111
   System.Data.Select.GetLinearFilteredRows(Range range) +527
   System.Data.Select.SelectRows() +368
   System.Data.DataTable.Select(String filterExpression) +65
   _Sitemap.ParsePathProducts(SiteMapNode Node, XmlDocument Construct, Int32& LinkCount) in D:\Sites\NiceSurprises\www\Sitemap.aspx.vb:103
   _Sitemap.ParseSitemapNode(SiteMapNode Node, XmlNode Parent, XmlDocument Construct, Int32& LinkCount) in D:\Sites\NiceSurprises\www\Sitemap.aspx.vb:94
   _Sitemap.ParseSitemapNode(SiteMapNode Node, XmlNode Parent, XmlDocument Construct, Int32& LinkCount) in D:\Sites\NiceSurprises\www\Sitemap.aspx.vb:89
   _Sitemap.ParseSitemapNode(SiteMapNode Node, XmlNode Parent, XmlDocument Construct, Int32& LinkCount) in D:\Sites\NiceSurprises\www\Sitemap.aspx.vb:89
   _Sitemap.GetSiteMapXML(String StartPath, Int32 Start) in D:\Sites\NiceSurprises\www\Sitemap.aspx.vb:37
   _Sitemap.Page_Load(Object sender, EventArgs e) in D:\Sites\NiceSurprises\www\Sitemap.aspx.vb:22
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832