0

No definition found for Table pidgets.airports

I'm attempting to select on the pidgets.airports table but I keep getting "No definition found for Table pidgets.airports"... Here is my query syntax:

select icao, name, city, state, country from pidgets.airports where near="san francisco";

And my request looks like this:

http://query.yahooapis.com/v1/public/yql?callback=jQuery1709747556946240366_1320605575897&q=select+icao%2C+name%2C+city%2C+state%2C+country+from+pidgets.airports+where+near%3D%22san+mateo%22%3B&format=json&diagnostics=true&appid=[redacted]&_=1320605575958

If I run this code directly in the console it works fine... Why doesn't it work when I call it over xmlhttp?

by
1 Reply
  • You are missing the env param in your http request. This works:<br><br>http://query.yahooapis.com/v1/public/yql?q=select%20icao%2C%20name%2C%20city%2C%20state%2C%20country%20from%20pidgets.airports%20where%20near%3D%22san%20mateo%22&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(Steve @ 6 Nov 2011 10:59 AM)</cite></div><blockquote class="quotemain">I&#39;m attempting to select on the pidgets.airports table but I keep getting &quot;No definition found for Table pidgets.airports&quot;... Here is my query syntax:<br><br><div>select icao, name, city, state, country from pidgets.airports where near=&quot;san francisco&quot;;<br><br>And my request looks like this:<br><br>http://query.yahooapis.com/v1/public/yql?callback=jQuery1709747556946240366_1320605575897&q=select+icao%2C+name%2C+city%2C+state%2C+country+from+pidgets.airports+where+near%3D%22san+mateo%22%3B&format=json&diagnostics=true&appid=[redacted]&_=1320605575958<br><div><br>If I run this code directly in the console it works fine... Why doesn&#39;t it work when I call it over xmlhttp?</div></div></blockquote></div>
    0

Recent Posts

in YQL