Re: How to post a null date variable to a table

[Deanna Schneider]

Here's a briefer syntax:
<cfqueryparam cfsqltype="cf_sql_timestamp" value="#AGT_TO_DTC#"
null="#yesNoFormat(NOT Len(trim(agt_to_dtc)))#">

----- Original Message -----
From: "Arden Weiss"

>
> <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 = null="#mTEST#" />
>      WHERE ID_NUMBER = '#mFINDIT#'
> </CFQUERY>
>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---