Are the names delimited by something (like commas) or just strung together?
On 4/27/07, Will Swain 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:276386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4