Like others, I think the database inserts 01/01/1900 by default when you insert the empty string " " or other non-date values, like integers. I also think configuring the database to set the value in the column to null won't solve the problem. The database engine would use null only when no data is inserted.
When the value " " or some such comes in, the database engine thinks, "Ah, a value has come in, so no need to insert the null". The result is the default 01/01/1900.
One answer is to check, before the insert query, whether the value is a date. Remember there are idiosyncrasies in Coldfusion that don't carry over to databases, like isDate("1a") returning 'yes'. So, before inserting, also check whether the format is compatible with that of the database column. If not, insert a null.
