Monday, July 18, 2005

SELECT MAX(NULL) FROM DUAL;

Never do that.
Actually, never SELECT MAX(col) FROM tab where col is a NULLable column on an Oracle client. Oh, and don't forget that an empty string is a NULL on Oracle.
It seems that the .NET framework has a bug, and, when you do this, you'll get a NullReferenceException from the .NET Oracle provider.
Weird.
Time to review all my SELECT MAX, SELECT MIN and convert from:
SELECT MAX(col) FROM tab
to
SELECT MAX(col) FROM tab WHERE col IS NOT NULL

Monday, July 11, 2005

I just keep running on weird errors

The Web server reported the following error when attempting to create or open the Web project located at the following URL: 'http://localhost/MyWebApplication1'. 'HTTP/1.1 500 Internal Server Error'.
Two hours later: we had an internal change on our network a few weeks ago, and the user/password on the processModel tag on MACHINE.CONFIG file was wrong. As you can see, I wasn't using ASP.NET so much...
I'm yet to see an IDE that gives less information than VS.NET when connecting to IIS...

This page is powered by Blogger. Isn't yours?