Saturday, May 09, 2009

Don't always AskTom

When trying to reach AskTom from my work PC - it errors out with a PL/SQL error:

... maybe there's a WHEN OTHERS too many in there? Maybe my browser string - HTTP_USER_AGENT - has gotten too long after having installed the latest version of the .NET-framework!?

HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 1.1.4322; InfoPath.2; .NET CLR 3.5.21022; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)

Internet Explorer (8) will do that to you sometimes :o(

Foreign NULLs!?

Jonathan Lewis has an interesting entry about how foreign keys handle nulls - see Foreign Keys!