4 Replies Latest reply on May 16, 2006 5:19 PM by The ScareCrow

    HELP! cfprocparam not sending NULL value

    shaunna_shelton Level 1
      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>