Re: testing for an undefined date

[Robert Everland III]

~|
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

[Tim Heald]

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

[daniel kessler]

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

[daniel kessler]

>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

[Charlie Hanlon]

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

[Tim Heald]

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

[Andy Matthews]

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

[daniel kessler]

>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