Good Question -- used it and got success -- both blank and populated date fields now post without error -- Whoooooooo Hooooooooo !!
But had trouble getting the exact syntax you suggested to work for me -- so ended up with the following construct -- probably can shorten it when I am awake in the am -- but your advice got me on the right track -- a gold star for your -- thanks
<CFIF #AGT_TO_DTC# EQ "">
<CFPARAM NAME = "mTEST" DEFAULT = "Yes" TYPE = "Boolean">
<CFELSE>
<CFPARAM NAME = "mTEST" DEFAULT = "No" TYPE = "Boolean">
</CFIF>
<CFQUERY NAME="TAB_UP" DATASOURCE="XXXX">
UPDATE MYTABLE
SET AGT_TO_DTC = <CFQUERYPARAM CFSQLTYPE="CF_SQL_TIMESTAMP"
VALUE = "#AGT_TO_DTC#" null="#mTEST#" />
WHERE ID_NUMBER = '#mFINDIT#'
</CFQUERY>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
