[thelist] early mornin' CF/access date tip

[rudy]

> Having trouble inserting a NULL value into an Access date field
> using ColdFusion?

never

this has always worked for me --

   insert into table_name (date_lastmodified) values ( null )

please note that there are times when an empty string is valid, 
a null value is wrong, and therefore so is the CPQUERYPARAM option
null="Yes" 

but when i want a null, i usually use the NULL keyword


rudy