Re: testing for an undefined date
~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229491 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
RE: testing for an undefined date
In your query you can do: Where event_date is null Or is not null In your cf you can do > -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: > whatsnew.event_date NEQ NULL> > > 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
Re: testing for an undefined date
It still seems to be enacting the code. I also tried I guess it's a date but an empty date or something like that since isDate didn't help. > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229493 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
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:229494 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
Re: testing for an undefined date
I have had difficulty trusting the isDate() function also. I fell back to using take action Charlie Hanlon - Original Message - From: "daniel kessler" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, January 13, 2006 1:28 PM Subject: Re: testing for an undefined date > It still seems to be enacting the code. I also tried isDefined('whatsnew.event_date')> > > I guess it's a date but an empty date or something like that since isDate > didn't help. > >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229495 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
RE: testing for an undefined date
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
RE: testing for an undefined date
Just wrap it in a CFIF statement. show code -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 12: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:229497 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
Re: testing for an undefined date
>Read further. ah I didn't see that at the bottom. That values to 0 so it doesn't enact. cool. thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229498 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