Retrieving Access database content with ASP then converting

wxdqz

New Member
Is it possible to automotically grab the source code of a ASP file, and paste it into an XML file?

I have an ASP file that retrieves data from an Access database, and it writes the output correctly, in the ASP file's source code, as:

-------------------------------------------------------------------------
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-
0.91.dtd">
<rss version="0.91">
<channel>
<item>
<title>
News story 1
</title>
<link>
<!-- m --><a class="postlink" href="http://www.link-for-news.com/news/pr.asp?id=267">http://www.link-for-news.com/news/pr.asp?id=267</a><!-- m -->
</link>
<description>
Short description of news story.
</description>
</item>
</channel>
</rss>
-------------------------------------------------------------------------

My question is, is it possible to automatically draw out the source code and save it as a XML file?

I'm currently doing this manually by:
1) Opening the ASP file, so that it retrieves the information from the database
2) Then go to my browser and View > Source Code
3) Highlight all the code, starting from <rss version="0.91"> to </rss>
4) Paste the code into my existing XML file.

This all works well, but I'd really like to automate this process if possible. Someone else may be taking over the monitoring and updating of the RSS news feed, and they may not have any technical knowledge at all.
 
Back
Top