Try IS instead of = .. at least that's what I do for SQL Server
Hatton John Kivus wrote: > 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
