fieldname IS NULL ----- Original Message ----- From: "John Kivus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 3: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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
