I have a verity collection of usernames, email addresses, etc. When searching on "somename@", I get results, but if I search on "[EMAIL PROTECTED]", no results are found (yes assuming that email address does exist).
Basically, if I add anything after the @ symbol, verity results croak. Here is attribute I am using from the <cfsearch> tag: criteria="`#Lcase(arguments.searchCriteria)#`*" If I remove the backquote, I get no results with the @ symbol, regardless of what's before or after it. I have tried various other iterations of the wildcard before and after the backquote, and without it altogether. Hoping someone has overcome a similar issue, -- Matt Williams "It's the question that drives us." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
