Sure. But it still wouldn't work. :) -----Original Message----- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: 27 April 2007 13:56 To: CF-Talk Subject: Re: Regex help looking for a name in a string.
It does really look like your using Regex's. Since you're looking for strings essentially, can't you just use ReplaceNoCase? On 4/27/07, Will Swain <[EMAIL PROTECTED]> wrote: > Ok, no doubt this is an easy RegEx question, but not for me. > > I have two queries. One returns a set of names, the other a string > which may or may not contain one or more of the names. > > I want to check for the existence of a name in the string, and if I > find it, make it a hyperlink. > > So far I have this: > > <cfset works_string = qry_getEvent.works> > > <cfloop query="qry_getProfiles"> > <cfset works_string = REReplaceNoCase(#works_string#, #artist#, "<a > href='profiles.cfm?e=#profileID#' target='artistWin'>#artist#</a>", > "ALL")> </cfloop> > > Which works in a limited sense but stumbles where names are similar or > contain the same words - for example > > John Smith > John Smith & Sons > > If the string contained John Smith & Sons, the code would highlight > the John Smith part but not the rest. > > Any suggestions? > > Thanks > > will > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4