I am attempting to update dates within an MS Access database with a NULL
value if the date was deleted on an update form. This code has worked in
the past, but seems to not be working now. Does anybody know a fix?
<cfquery datasource="#DSN#">
UPDATE tblStatusMilestones
SET TargetEndDate =<cfif MilestoneEndDate neq
"">'#form.MilestoneEndDate#'
<cfelse>NULL
</cfif>,
CurrentStatus = '#form.MilestoneStatus#'
WHERE StatusMilestoneID = #form.StatusMilestoneID#
</cfquery>
Kory Bakken
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
