CFOUTPUT Date if it is NULL

[susanh]

Hi everyone,
I am having a serious time remembering if you can do this or not. It has been a while.

Can tell Coldfusion to cfoutput a date field if the table shows that it is NULL?

I define it here
<cfif isdefined("GetProject.duedate") and len(trim(GetProject.duedate))>
<CFSET DueDate="#dateFormat(GetProject.duedate, "MM/DD/YYYY")#">
<cfelse>
NULL
</cfif>

Then <cfoutput> this
<cfinput name="DueDate" type="text" value="#DueDate#" size="10" tabindex="2" class="TextInput" onFocus="setFieldBGColor()" onBlur="resetFieldBGColor()">

But when I view it. I get an Variable DUEDATE is undefined error.

What am I doing wrong?

Thanks
Sue

 

[ecobb]

<cfif isdefined("GetProject.duedate") and len(trim(GetProject.duedate))>
  <CFSET DueDate=dateFormat(GetProject.duedate,'MM/DD/YYYY')>
<cfelse>
  [red]<CFSET DueDate="">[/red]
</cfif>

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher