Are you on CFMX 6.1? This should work for you if you are:
<CFQUERYPARAM
CFSQLTYPE="CF_SQL_TIMESTAMP"
VALUE="#AGT_TO_DTC#"
NULL="#Len(AGT_TO_DTC) EQ 0#" />
The above doesn't work? Odd.. Try it like I have it above... It will save
you a few lines of code... If that matters to you.
Mike
> <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]
