Null isn't the same as an empty field. Try where supplier_name IS '';
-- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 11:18 AM To: CF-Talk Subject: Re: SQL status <> 'Removed' Sorry, I think it should be IS NULL. NULL does not equate to anything so = will not work. Example: select * from suppliers where supplier_name IS NULL; On 8/9/07, daniel kessler wrote: > > > status <> 'Removed' OR Status = NULL > > This also didn't work. I received no error, but no more items showed than > before. > > daniel > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
