assuming the column accepts NULL values (and if not, you'll need to set it so that it does)...
use the following value in your SQL: myDatabaseDate = <cfqueryparam value="#form.MyDateVal#" cfsqltype="cf_sql_date" null="#yesNoFormat(NOT len(trim(form.MyDateVal)))#" /> On 9/19/07, Chad Gray <[EMAIL PROTECTED]> wrote: > I have a form that asks for a date. > > If no date is entered into the form what gets inserted into the database is > 01/01/1900. > > How do I get the database to have NULL or blank and not this date 01/01/1900? > > I don't know if it is best to try to fix this on the database side or write > cfif's to see if the form variables is blank. > > Thanks! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
