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
[EMAIL PROTECTED] | www.humankinetics.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
