I have a field that allows Nulls.
It auto populates nulls as
"1970-01-01 00:00:00"
I used the following code to try to make it work and also tried various
examples of "IsNull" and could not seem to get it to work.
What am I missing/
<cfif #ShipDT#="1970-01-01 00:00:00"><strong>Not Yet Shipped</strong>
<cfelse #ShipDT#>
</cfif>
CF Error states:
The error occurred in
C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\shipping\editShipDate.cfm:
line 58
56 : <td bgcolor="##FFFFFF">#Shipment_ID#</td>
57 : <td bgcolor="##FFFFFF">
58 : <cfif #ShipDT#="1970-01-01 00:00:00">
59 : <strong>Not Yet Shipped</strong>
60 : <cfelse #ShipDT#></cfif></td>
coldfusion.compiler.ParseException: Invalid CFML construct found on line 58
at column 31.
I want it to say:
If
"shipdate" is null, or has that date in it
then
text "Not Yet Shipped"
Else
Output the "shipdate"
What am i overlooking?
Robert P. Reil
Managing Director,
Motorcyclecarbs.com, Inc.
4292 Country Garden Walk NW
Kennesaw, Ga. 30152
Office 770-974-8851
Fax 770-974-8852
<http://www.motorcyclecarbs.com/> www.motorcyclecarbs.com
