Hi Steve,
I think you can solve your problem by including the following prior to your select statement: "use 'http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml';"
Therefore, your entire YQL statement should look like the following: "use 'http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml'; select * from yahoo.finance.quotes where symbol in ('YHOO', 'GOOG', 'GE')"
Maybe someone can help me out with an issue I've ran into in the last few days...
I'm having some issues with the options table where the query is returning no value after a number of passes. If I attempt to restart the script it kicks out immediately.
I was reading somewhere that Yahoo limits queries to 1,000/hr... This was not a problem when I ran the script a few days ago. Not to mention it looks like my script only made it through less than 600 queries before it started returning no value.
Anyone have any suggestions?