Well a little screen scraping on Mike's link will get you most of the way there. From that point it's one join away. That's mostly automated. After the initial data import, it will be manually tweaking data in a simple crud app.
-nathan strutz http://www.dopefly.com/ On 9/5/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Because then you have to enter pairs manually. He's looking for something > that's automated. > > <!----------------//------ > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > -----Original Message----- > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > Sent: Sunday, September 03, 2006 5:58 PM > To: CF-Talk > Subject: Re: Peg = Margaret name matching code > > > Why not just create two database tables, one with id(int) and > formalname(varchar), the second with formalnameid(int) and > nickname(varchar) and populate starting with names from the URL you > mentioned, then bounce your names against that? > > Pete > > On 9/3/06, Mike Chabot <[EMAIL PROTECTED]> wrote: > > Does anyone know of code that can match formal names, such as > > "Michael" with their less formal equivalents, such as "Mike." I was > > starting to code this but stopped after realizing that there were > > thousands of these nicknames. I am mainly interested in names, but > > matching addresses abbreviation, such as "Blvd" = "Boulevard" might be > > helpful as well. > > > > <http://www.usgenweb.org/research/nicknames.shtml> > > > > Someone recommended Blue Fusion CS (which sounds like an Adobe > > product, but it isn't), but that software is quite expensive. I would > > hope there is something free out there which covers the basics. > > > > CFMX 7 Ent / Win2003 / IIS6 / MS SQL Server 2005 > > > > Thank you, > > Mike Chabot > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
