TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Server
Cold Fusion Server Tech

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Server:
Subject: Re: How to detect if a Date field is NULL

Bruce Ford (4p/+0r) Posted: Thursday 04 Jan 2001
This post: 44 views, +0 rating

Perhaps your subject line gives the answer. Have you tried

WHERE LastUpdated IS NULL

>I am relatively new at Cold Fusion so pardon me if there is an easy answer >to this and I just have not been able to find it. > >I have a field called LastUpdated which is a DATE formatted field. While >doing a query, I am trying to find all records where that field is empty. >So far I have not had luck. I tried... > >WHERE LastUpdated = "" and it errors >WHERE LastUpdated = 0 and it errors > >How can you detect if a date formatted field is empty? > > >Mitch Duszynski >Web Developer >Human Kinetics >PO Box 5076, Champaign, IL 61825 >Tel 217-351-5076 x2474 | Fax 217-351-2674 >mitchd@hkusa.com | www.humankinetics.com

Bruce Ford b.ford@qut.edu.au Online Teaching Systems Coordinator Teaching and Learning Support Services Ph: +61 7 3864 9773 Queensland University of Technology

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Similar Subject Line Posts (+/- two weeks of this post)

Encrypted Email [WAS RE: How to detect if a Date field is NULL]	06 Jan 2001	(32 v/ +0 r)
RE: How to detect if a Date field is NULL	05 Jan 2001	(27 v/ +0 r)
RE: How to detect if a Date field is NULL	05 Jan 2001	(17 v/ +0 r)
RE: How to detect if a Date field is NULL	04 Jan 2001	(24 v/ +0 r)
Re: How to detect if a Date field is NULL	04 Jan 2001 (this post)	(44 v/ +0 r)
How to detect if a Date field is NULL	04 Jan 2001	(22 v/ +0 r)

Send a reply to the CF-Server list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)