On Mar 9, 11:59 am, Asif <[email protected]> wrote: > > Now there is change in requirement.
Hmm... are we being asked to write your code for you? > The application should find out all the objects that are located in > Amsterdam, also the objects which are not exactly located in Amsterdam > but nearby having service range up to Amsterdam. > > So i have known latitude, longitude values for Amsterdam returned by > google map, also the objects having respective lat,lng value and > service range/radius stored in database. How can i make it possible? If you give Amsterdam a point location, then you can just select every object which is within range of Amsterdam. select * from table where (distance to Amsterdam) < (service_range) That will select everything within range of Amsterdam, whether it's in Amsterdam or outside the city. For objects within Amsterdam, the distance will [presumably] always be less than their service range, so they will always be included -- and if the distance from an object is more than its service range you don't want to include it anyway. 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 -~----------~----~----~----~------~----~------~--~---
