Use where fieldname IS NULL
Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "John Kivus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 12:22 PM Subject: Basic SQL Question > I'm using Access to develop a demo site and I'm trying to pull the > records which have a date/time field which is not filed in. I tried to > say WHERE fieldname = NULL, but that doesn't seem to do the trick. Is > there a keyword that I can use instead of NULL to get the same result or > do I have to add a flag to see that the record has been updated? > > John Kivus > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/[email protected]/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
