Mitch,
Try WHERE LastUpdated IS NULL. See if that works.
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603 Fax 210-490-4692
> -----Original Message-----
> From: Mitch Duszynski [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 04, 2001 2:45 PM
> To: CF-Server
> Subject: How to detect if a Date field 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
