Read further. > -----Original Message----- > From: daniel kessler [mailto:[EMAIL PROTECTED] > Sent: Friday, January 13, 2006 1:30 PM > To: CF-Talk > Subject: Re: testing for an undefined date > > >In your query you can do: > > > >Where event_date is null > > > >Or is not null > > > > I still want the record, but I just don't want to try and > display the html for the date if the date doesn't exist. It > adds a line for it. > > thanks! > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229496 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54