2010年1月26日 星期二

another rss example to get news about xmpp

select title, link from rss
where url="http://xmpp.org/extensions/rss.xml"

2010年1月20日 星期三

weather forecast for Rowland Hts., CA

select * from weather.forecast where location=91748

rss example

select title, link from rss
where url="http://www.nytimes.com/services/xml/rss/nyt/HomePage.xml"

stock quotes example

select symbol, price from csv
where url='http://download.finance.yahoo.com/d/quotes.csv?
s=IBM,YHOO,GOOG,MSFT&f=sl1d1t1c1ohgv&e=.csv' and
columns='symbol,price,date,time,change,col1,high,low,col2'

2010年1月13日 星期三

YQL query

select * from flickr.photos.info where photo_id in (select id from flickr.photos.search where woe_id in (select woeid from geo.places where text="san francisco, ca") and tags = "fog")