DOES NOT CONTAIN is the syntax you're looking for I think - or just check the existence of FOR using CONTAINS and not LIKE ... LIKE is SQL, CONTAINS is CF.
Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 3:19 PM To: CF-Talk Subject: RE: CF 5 CFIF NOT LIKE <cfif not (variables.productDesc like "For")>Free Gift</cfif> not tested, but should work.... ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 3:12 PM To: CF-Talk Subject: CF 5 CFIF NOT LIKE I need to verify if a field does NOT contain "FOR " ... I have tried <CFIF #ProductDesc# IS NOT LIKE "FOR ">FREE GIFT</CFIF> and <CFIF #GetProduct# NOT CONTAINS "FOR ">FREE GIFT</CFIF> but both choke... For now I am using <CFIF #GetProduct# CONTAINS "FOR "><CFELSE>FREE GIFT</CFIF> Which is clugy - I need a way to do it without the CFELSE... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
