XML and ASP

Hi,

I'm trying to read a moreover news feed and then store that information in a
database. The problem that I am having is with reading the feed from the
script. Is this the correct way to read a feed over http rather than an XML
file ? Is there an easier way to handle dumping XML info directly into a
database ?

Thanks,

J



Script :

Dim strtitle,strlink,strdescription,strguid,strpubDate,strsource
Dim xml,xmlURL
xmlURL="http://p.moreover.com/cgi-local/page?o=rss002&c=UK%2 0immigration%20news"
Set xml = Server.CreateObject("Microsoft.XMLDOM")
xml.setProperty "ServerHTTPRequest", true
xml.async = False
xml.load (xmlURL)
Dim NodeList
Set NodeList = xml.documentElement.selectNodes("item")
Dim Node
For Each Node In NodeList
strtitle = Node.selectSingleNode("title").Text
strlink = Node.selectSingleNode("link").Text
strdescription = Node.selectSingleNode("description").Text
strguid = Node.selectSingleNode("guid").Text
strpubDate = Node.selectSingleNode("pubDate").Text
strsource = Node.selectSingleNode("source").Text
Next

'See if anything was read properly

Response.Write(strtitle)



XML layout from feed :




http://www.moreover.com/rss

Moreover Technologies

en-us


http://i.moreover.com/pics/rss.gif
http://www.moreover.com/rss
144
16

Moreover Technologies





http://www.lalala.com


Ad - Over 85 locations and online programs available. Request free info.

ad20070323120000
Fri, 23 Mar 2007 14:31:00 GMT

Re: XML and ASP

hi john, are you still strugling with getting the feed to work? i have
written a class which reads feeds .. just let me know if you still
need it.