I need to write an ASP script that will take a given RSS address and parse the xml and submit the items to a database. I can do all the database stuff, and had planned on using MSXML2.ServerXMLHTTP.3.0 to get the actual file. I can do all this, however I can not easily covert the XML page to variables which can be inserted into a database. Surely this has been done a million times, but the only examples I can find are ASP.NET which i am not interested in.
The link i am using for my test is: http://blog.mlive.com/saginawnews_impact/atom.xml. I basically just want to grab that file with MSXML2, then loop through each and get each item into a variable which will be submitted. I am sure I can do this with a series of instr() commands but there has to be a better way. Please help!