"CFQueryParam and NULLs" update

After my earlier post describing the various issues I was having with ODBC drivers, things didn't really turn around. In fact, I kept running into more and more issues that appeared to be driver specific. I then became one of the many ColdFusion developers that tried to get the JDBC driver to work on a Windows XP SP2 machine, only to have Windows Firewall (and other SP2 related stupidity) stop things from working. Fortunately I came across this post from Dough Hughes mentioning the SQL Server Critical Update Wizard ...and that solved the problems! Yes, plural: "problemS". I'm now happily running the JDBC drivers, and am able to use cfqueryparam in ALL cases (my earlier post noted not being able to check "datetime" fields) with no issues. This enabled me to remove some "home grown type checking" code from my DAO classes, reducing the code complexity, and probably getting me a minor speed improvement as well. Thanks Doug!