DB to XML - Best way to automate

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J-P-W - 04 Oct 2008 17:46 GMT

I have two XML files that a generated from a database.

Presently I have to go into my admin section to click a link that
loads the pages that in turn create the pages.

As my database is updated (new entries relating to property sales)
this is a bit of a pain.

Has anyone dealt with this issue before?

I could have it so that when the home page is loaded the XML files are
generated - but this seems to be far to frequent, but the home page is
the only page I can guarantee is loaded!

Perhaps I should keep track of page creations, and perhaps look at the
last entry, if it's older than say 15 minutes then create the pages ??

This is not a code question, more advice on how this has been dealt
with by others. [I can't create a scheduled event on the server - it's
a shared one]

Many thanks

Jon

Reply to this Message

Mike Brind - 05 Oct 2008 17:18 GMT

>I have two XML files that a generated from a database.
>
[quoted text clipped - 20 lines]
>
> Jon

Why not just add some code to regenerate the files at the end of the script
that adds a new entry?

--
Mike Brind
MVP - ASP/ASP.NET

Reply to this Message

J-P-W - 05 Oct 2008 22:13 GMT

> >I have two XML files that a generated from a database.
>
[quoted text clipped - 29 lines]
>
> - Show quoted text -

Hi Mike,
My only thought was because the pages can be edited a number of times,
but
of course that's the only way of being sure that it's up to date.....
not
seeing the wood for the trees perhaps?
Yes I'm sure you're right!
Thanks
Jon

Reply to this Message

Webmaster Forum / ASP / Database Access / October 2008

DB to XML - Best way to automate