You can also use "neq"
ContactCnt neq 'Do Not Contact'
-- Sam
-----------------
-----Original Message-----
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:13 AM
To: CF-Talk
Subject: RE: using != in a filed with a null value
I have always used "<>" for NOT EQUAL. Give it a try ^_^
+--------------------------+---------------------------+
| SCOTT VAN VLIET | SBC SERVICES, INC. |
| Senior Analyst | ITO Enterprise Tools |
| Tel: 858.886.3878 | 7337 Trade St. Room 4000 |
| Pgr: 858.536.0070 | San Diego, CA 92121 |
| Email: [EMAIL PROTECTED] | http://www.sbc.com |
+--------------------------+---------------------------+
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:13 AM
To: CF-Talk
Subject: RE: using != in a filed with a null value
> The weird thing is if I use that with my whole query which is
>
> Select * From customerLeads
> Where TodaysDate = '#DateFormat("TodaysDate", "mm/dd/yy")#'
> And Email Like '%@%'
> And Email Like '%.%'
> And ContactCnt != 'Do Not Contact' Or ContactCnt is Null
>
> It totally ignores the date part and grabs everything. This
> is very strange that it is doing this.
That might be because you have that OR in there, I guess. Try replacing your
last filter with this:
AND (ContactCnt != 'Do Not Contact' OR ContactCnt IS NULL)
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
