select * from geo.places where text="Den Haag" and country.code="NL"
It returns a single result, where place->name is "The Hague". I need the name to be the local name "Den Haag" in order to reliably do a double check on my end. in Yahoo Placemaker this is possible by adding &locale=nl, but I don't see how to tell YQL to do the same... Of course, I can't expect my client to enter English city names on his website, so I need a better solution.
Hi Martijn,<br><br>You can specify the <span style="font-family:'Courier New';">lang</span> in the query and the results (should) respect that.<br><br><span style="font-family:'Courier New';">select * from geo.places where text="Den Haag" and country.code="NL"<strong> and lang="nl"</strong><br></span><br>(<a href="http://developer.yahoo.com/yql/console/?q=select%20*%20from%20geo.places%20where%20text%3D%22Den%20Haag%22%20and%20country.code%3D%22NL%22%20and%20lang%3D%22nl%22">Try this in the console</a>)<br>