In your query you can do: Where event_date is null
Or is not null In your cf you can do <cfif len(trim(whatsNew.eventDate))> > -----Original Message----- > From: daniel kessler [mailto:[EMAIL PROTECTED] > Sent: Friday, January 13, 2006 1:09 PM > To: CF-Talk > Subject: testing for an undefined date > > I can't seem to get this to work. I have a date field in an > Oracle DB, created as event_date date. > It has a date field that's not required so it's only filled > in when a date is available. How do I test to see if it's > empty or not? I did: > <cfif whatsnew.event_date NEQ undefined> <cfif > whatsnew.event_date NEQ NULL> <cfif whatsnew.event_date NEQ ''> > > thanks. > > > daniel > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54