Not knowing the exact logic, I believe you need to change to this.

<cfif "United States" Contains Country and "K-12" does not contain
intype and ((State is "IL") or (State is "IA"))>

Better yet:

<cfif listFindNoCase(Country, "United States), and NOT
listFindNoCase(intype, "K-12") and listFindNoCase("IL,IA", State)>

Steve


-----Original Message-----
From: Orlini, Robert [mailto:rorl...@hwwilson.com] 
Sent: Monday, March 22, 2010 11:51 AM
To: cf-talk
Subject: Does not contain dilema


I have a form with a field call "intype" which I need to filter and NOT
send an email if the form does contain a certain list of states, but
does not contain the value "k-12" for intype.

The cfif I have that does not seem to work is:

<CFIF "United States" Contains Country and "K-12" does not contain
intype and "IL" Contains State or "IA" Contains State>.

I've tried, but it still sends the email which I don't want:

<CFIF "United States" Contains Country and "K-12" does not contain
intype and (State is "IL") or (State is "IA")>

Any easier way to do this please?

Thanks.

RO
HWW




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331948
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to