that should be "It doesn't really look like your using Regex's" On 4/27/07, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > 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:276384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4