quote: Ok, then why doesn't <cfif thedate is NULL> work?
Because ColdFusion does not really have the concept of NULL values. In cfquery results, any NULL values are essentially converted to an empty string ie "". So your cfif conditions should test accordingly. As mentioned, you can also use functions like IsDate(), IsNumeric(), etecetera if it is more appropriate for the given value.
This message was edited by cfSearchin on 3-31-10 @ 6:07 PM