HELP! cfprocparam not sending NULL value

[shaunna_shelton]

I'm trying to send the value null to my stored procedure if the value of conf_date is 1/1/1900. It's not working! Here's how I'm trying to do it:

<cfif arguments.conf_date EQ "1/1/1900">
<cfprocparam type="in" cfsqltype="cf_sql_date" dbvarname="@conf_date" null="yes">
<cfelse>
<cfprocparam type="in" cfsqltype="cf_sql_date" dbvarname="@conf_date" value="#arguments.conf_date#" null="no">
</cfif>

[Dan_Bracuk]

I was curious so I looked it up.

The reference manual says,
"Optional. Yes or No. Indicates whether the parameter is passed as a null. If you specify Yes, the tag ignores the value attribute."

You don't have a value attribute to ignore. Maybe that's it, maybe it's not.

[hrpatel34]

try this
<cfif arguments.conf_date EQ "1/1/1900">
<cfprocparam type="in" cfsqltype="cf_sql_date" dbvarname="@conf_date" value="null" null="yes">
<cfelse>
<cfprocparam type="in" cfsqltype="cf_sql_date" dbvarname="@conf_date" value="#arguments.conf_date#" null="no">
</cfif>

[CF_Oracle]

Just in case you use CF MX or CF 7 (this is from live docs):
Changed the dbvarname attribute behavior: it is now ignored for all drivers. ColdFusion MX uses JDBC 2.2 and does not support named parameters.

[The_ScareCrow]

I seperate the logic from the tag

<cfif arguments.conf_date EQ "1/1/1900">
<cfset dateNull = "Yes">
<cfelse>
<cfset dateNull = "No">
</cfif>
<cfprocparam type="in" cfsqltype="cf_sql_date" dbvarname="@conf_date" value="#arguments.conf_date#" null="#dateNull#">

Ken