If you have a large data set, this method has a lot of overhead becuase you have to compute the distances for every row.
Troy Sosamon -------------- Original Message Put the (x,y) co-ordinates in the DB along with the location name. Latitudes and longitudes could work. Then show everything with a radius of N degrees, or show the M closest entries: If I recall, Distance=((x2-x1)^2 + (y2-y1)^2)^(.5) Of course, the actual distance will only be approximate for longitudes... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Henning Sittler Sent: Tuesday, May 21, 2002 12:01 PM To: Multiple recipients of list witango-talk 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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
