Simple Dumb Question - Null for Date/Time Field

[Paulie579]

using cf mx ms sql 2000. i have an update form that contains a field for date a
procedure was signed. the problem is if the procedure was not signed, the user
doesn't enter anything into the date field. but when they click the update
button the update query inserts 1900-01-01 00:00:00 into the field in the db.

[jorgepino]

inside the update query you could do something like this

<cfif form.updateddate neq "">
Updateddate = '#form.updateddate#'
</cfif>
only when updateddate is fill it would update the date field

[Paulie579]

thanks

[ssawka]

Another option would be to use the <CFQUERYPARAM> tag. Something like:

<cfset updatedate_null = not IsDate(form.updatedate)>

<cfquery>
update Table
set Updatedate = <cfqueryparma value="#form.updatedate#"
null="#variables.updatedate_null#">
where ...
</cfquery>

That way an actual "null" will be sent if form.updatedate is not a date.

Hope this helps,
Sean