Re: testing for an undefined date

2006-01-13 Thread Robert Everland III 
cfif isDate(whatsnew.event_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

2006-01-13 Thread Tim Heald 
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

Re: testing for an undefined date

2006-01-13 Thread daniel kessler 
It still seems to be enacting the code.  I also tried cfif 
isDefined('whatsnew.event_date')

I guess it's a date but an empty date or something like that since isDate 
didn't help.

cfif isDate(whatsnew.event_date)

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

2006-01-13 Thread 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

2006-01-13 Thread Charlie Hanlon 
I have had difficulty trusting the isDate() function also.  I fell back to 
using

cfif isdefined(whatsnew.event_date) and  len(trim(whatsnew.event_date)) 
gt 0
take action
/cfif

Charlie Hanlon

- Original Message - 
From: daniel kessler [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
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 cfif 
 isDefined('whatsnew.event_date')

 I guess it's a date but an empty date or something like that since isDate 
 didn't help.

cfif isDate(whatsnew.event_date)

 

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

2006-01-13 Thread 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

2006-01-13 Thread Andy Matthews 
Just wrap it in a CFIF statement.

cfif yourdatefield IS NOT show code/cfif

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-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

2006-01-13 Thread 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