On Mar 10, 6:01 am, Asif <[email protected]> wrote: > Absolutely above solution is working. But not always. There might > be objects that are in Amsterdam but having service range less than > the distance from Amsterdam. > > For e.g. if my object is 51 KM apart from Amsterdam but having > service range 50 KM. Now above solution doesn't include this point as > service range less than the distance from Amsterdam. > We have to display all the objects that resides in Amsterdam and also > the objects which are not in Amsterdam but having service range in the > Amsterdam
This is outside the scope of this group (it's about SQL and not the Maps API). And your requirement seems to be changing with every post. If you have a service range of 50km, and your object is 51km away, it's outside the service range. If you use select * from table where (distance to Amsterdam) < (service_range) then objects which are less than 50km away from Amsterdam will be returned, whether they are within Amsterdam or not. You may end up using "union" queries; and you be better off asking in a forum or Group which specialises in SQL. Andrew --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
