Geeks With Blogs

Tim Huffam Dotting the I and crossing the T of I.T. July 2006 Entries
VS Collection Manager location. Registering/enabling html help collections.
Use the Collection Manager to enable/disable which html help collections are available to your Visual Studio IDE (dynamic help etc). For VS.NET 2003 use: ms-help://MS.VSCC.2003/VSCC... For VS2005 use: ms-help://MS.VSCC.v80/dv_vs... For more info see the FAQ at the Helpware Group's web site. HTH Tim ......

Posted On Thursday, July 13, 2006 8:52 AM

Case insensitive XPath

XPath statements are case sensitive.  To get around this use the following example to convert all data to lower case before performing the equality check:

/bookstore/book[translate(@category, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') = '" + searchtext.ToLower() + "']

Thanks very much to Harish for this!

Posted On Thursday, July 6, 2006 11:01 AM

Cannot add diagram to SQL Server 2005 DB: Database diagram support objects cannot be installed because this database does not have a valid owner.
When trying to add a diagram to an SQL Server 2005 db I got the following error:Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. I tried the suggestion mentioned in the message but that didnt work. Also found that SQL Server Management Studio ......

Posted On Wednesday, July 5, 2006 7:36 PM

Error: System.Net.WebException: Too many automatic redirections attempted.
This error can occur when an application performs a web request to a web app that's trying to interogate the Request.UserAgent - but the requesting app has not set the user agent in the request. To resolve either set the user agent before sending the request eg: HttpWebRequest req = (HttpWebRequest) HttpWebRequest.Create(theUr... (compatible; MSIE 6.0; Windows NT 5.1)"; Alternatively, and preferrably (if you have access to it), fix the server side web application to check ......

Posted On Tuesday, July 4, 2006 2:45 AM

Copyright © Tim Huffam | Powered by: