Man, why can't CF just support null...oy...

Explanation of the problem
Example of the problem in play

Best semi-official info on this issue is in the CD attached to the CFMX& web app construction kit book. See chapter 30, Working with NULL values section.