I have checked the distance from (37,-122) to Giorgio's (1445 Foxworthy Ave, San Jose, CA) the distance showing in http://maps.google.com as 29.9 miles. But you said 19.87 miles is the correct result. Can you please provide me the url where i can check the result.
And also can you please check my SQL Query and suggest me the correct one or any url. Thanks, Srikanth On Jan 22, 4:20 pm, Andrew Leach <[email protected]> wrote: > On Jan 22, 8:09 am, srikanth <[email protected]> wrote: > > > We have used the store example from > > -http://code.google.com/apis/maps/articles/phpsqlsearch_v3.html, > > when we have executed the MySql query we got the following results - > > > Both the distance values from MySql and SQL are not same as given in > > the google example, dont know why, google example is also not working. > > You appear to have omitted the ORDER BY clause in your translation, > which will certainly result in a different result set. > > The MySQL results look correct. Giorgio's is 19.87 miles from > (37,-122). Consequently the problem must be in your SQLServer > implementation -- either the DBMS is miscalculating, or your database > is set up wrongly. Not sure how we can help with that. > > 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.
