Query internet db for information

Hello everyone, I'm trying to figure out how to query the average temperature for a given zip code programmatically. Are there any sites that allow direct querying or something similar? What I'm wanting to do is to present the current temperature and yearly average temperature for a zipcode. This zipcode would be provided by my database and in turn I would use that variable to do my query. Any ideas? Thanks in advance

 

I have decided to utilize XML for this purpose. I'm a little rusty so please help me out. The address I am using for the information is

http://weather.yahooapis.com/forecastrss?p=10101

Code (markup):

What I need to understand is how to use this feed as an ADODB recordset. Here is what I have so far:

<%
objXML.Load ("http://weather.yahooapis.com/forecastrss?p=10101"

If objXML.parseError.errorCode <> 0 Then
Response.Write "<p><font color=red>Error loading the weather data, contact the webmaster.</font></p>"
Response.End
End If
%>

Code (markup):

What I'm trying to get out of this is the current temperature for that zip code. Any help would be most appreciated. Thank you.

 

ADODB recordset.

 

Better use LINQ to XML it's VERY EASY.

Quick sample for parsing XML document:
http://www.hookedonlinq.com/LINQtoXML5MinuteOverview.ashx

 

Well, LINQ would be fine if I was using asp.net however this is classic ASP. Someone mentioned ADODB for the XML...do you have any examples of that?

 

search for : developer yahoo weather in google, there are also examples provided by yahoo how to parse xml