My bad... I retract that... ----- Original Message ----- From: "Josh Remus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 9:40 AM Subject: RE: NULL Madness
> WHERE orderCount IS NULL? > > > -----Original Message----- > > From: David K [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, July 23, 2003 12:37 PM > > To: CF-Talk > > Subject: SOT: NULL Madness > > > > > > <Brain_Cramp> > > > > Trying to do a simple select query that > > selects all records with an empty value in > > an integer column. The table contains 122 > > records where 12 records have an empty > > value in the target column. Here's my query... > > > > <cfquery name="getData" datasource="cfDS"> > > SELECT * > > FROM tblCustomers > > WHERE orderCount = NULL > > </cfquery> > > > > ...which returns *0* records in the result set. > > > > However, if I run this query... > > > > <cfquery name="getData" datasource="cfDS"> > > SELECT * > > FROM tblCustomers > > WHERE orderCount <> NULL > > </cfquery> > > > > ...the result set contains 110 records as expected. > > > > Isn't the second query the logical opposite of the first? > > If yes, why does the first query not return 12 records? > > What is the correct query syntax to return a result set > > containing those 12 records? > > > > </Brain_Cramp> > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
