I believe you have to do CONTAINS "##" to escape the pound sign.
-----Original Message----- From: Barry Mcconaghey [mailto:[email protected]] Sent: Tuesday, September 22, 2009 11:19 AM To: cf-talk Subject: Re: Coldfusion Autosuggest I think I found the problem. In my Database, I found some entries like "Acme # 1". Because I have a large DB, how can I display only the names with the symbol "#" in them. For Example: <cfoutput query="ratings"> <cfif #ratings.fdd_name# CONTAINS "#"> #ratings.fdd_name# </cfif> </cfoutput> But this query does not work. Barry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
