<cfqueryparam
value="#CreateODBCDate(FORM.paidThru)#"
cfsqltype="cf_sql_date"
Null="#YesNoFormat(Trim(FORM.transactionType LTE 5))#>
If YesNoFormat(Trim(FORM.transactionType LTE 5)) results in NO then the
value attribute is passed in.
If YesNoFormat(Trim(FORM.transactionType LTE 5)) results in YES then the
value attribute is ignored and NULL is passed in.
Mike
> When the null attribute is set to yes, the value attribute is
> ignored so leave it like value=""
> > So what would the value be? I want a <Null> put into the SQL 2000.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
