Creating an RSS (XML) file with ASP

Hi all,

I have a database of 1000 properties. I would like to create an ASP or possibly a VBS file which will execute daily at a certain time, delete the old XML file, create a new XML file and write the RSS information it gets from the database with a loop. How can I create file and write information? Any ideas or examples?

Thanks

You could "cheat" in ASP. Rather than execute your XML file change at a predetermined time you could have your page decide whether to load a new file or to output the old file whenever the page is requested. You would need to "lock" the file swap over in the Application object to ensure no more than one request attempts to write a new file while another request has already started, but not finished, this.

If creating the new XML file takes too long for this approach, you could implement the XML swap in VBS and execute it in a Scheduled Task.