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.
