I have just joined up to Yahoo to be able to use YQL to make web search requests.I have an appid as well.

But if I go to the console do do some test
http://developer.yahoo.com/yql/console/

This query doesnt work
select * from search.web where query="hello"
It gives the error
Cannot find required keys in where clause; got 'query', expecting required keys: (query, appid)


If I try to pass in my appid like this

select * from search.web where query="hello" and appid="MYAPPID"

It doesnt work either. I get this as the response
<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
yahoo:count="0" yahoo:created="2011-05-02T16:49:25Z" yahoo:lang="en-US">
<results/>
</query>





So my questions are:
What is the propblem?
How do I pass in my appid properly?
Can anyone show be an example of what the query should look like?

You are passing the appid in correctly in your query (just added appid='....' in the where clause). Perhaps there potentially might be an issue with the appid.

A couple questions, how did you create your appid? How many characters long is your appid? To be clear a standard appid usable in BOSS (and thus the search.web table) should be 64 characters long and alphanumeric.

You can generate one from this site:

https://developer.apps.yahoo.com/wsregapp/

and you can view your current appids here:

https://developer.apps.yahoo.com/wsregapp/?view

If you appid, shows up on those pages and is 64 characters long you should be able to use it in your search.web query.

--Josh