Re: Witango-Talk: DB Searches - Nearby Cotunries

[[Gauthier]]

Title: DB Searches - Nearby Cotunries

My primary reflex should be to create the table that you describe 'related_region' with 2 foreign key on your regionId.    even if some service (web service?) exists that return the result that you need this table to store the info (whenever the infos are populated automatically or handly).   Gauthier ----- Original Message ----- From: Henning Sittler To: Multiple recipients of list witango-talk Sent: Tuesday, May 21, 2002 6:01 PM Subject: Witango-Talk: DB Searches - Nearby Cotunries Any suggestions on how I can implement a database search which returns rows for not only the requested State and/or country but also rows for geographically surrounding and nearby states or countries? I guess I could create a manually populated table of nearby states or countries (lets call them regions to be more general) for each region.  Are there any services out there which provide this kind of info?  Is there a site that can offer this raw data initially?  If I can get or pull this from somewhere, it would be preferred over doing things manually. Thanks much, Henning Sittler www.inscriber.com