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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4