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
>[EMAIL PROTECTED] | www.humankinetics.com
Bruce Ford [EMAIL PROTECTED]
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 [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
