Skip to main content
J
jwcrosby
Participant
September 2, 2008
Question

Query database daily automatically

  • September 2, 2008
  • 1 reply
  • 374 views
I have a database (MSAccess) that users can access and add records. Individual pages are in ASP and everything is working well.

What I want to do now is to query the database once a day, automatically, to look for changes based on a particular date field. I haven't a clue if it is even possible to automatically open and run an ASP page unattended. Not even sure if I'm asking the right question in the correct forum (sorry if I'm not!)

Anyone help? Thanks in advance.

Jerry
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
September 3, 2008

"jwcrosby" <webforumsuser@macromedia.com> wrote in message
news:g9keop$c14$1@forums.macromedia.com...
>I have a database (MSAccess) that users can access and add records.
>Individual
> pages are in ASP and everything is working well.
>
> What I want to do now is to query the database once a day, automatically,
> to
> look for changes based on a particular date field. I haven't a clue if it
> is
> even possible to automatically open and run an ASP page unattended. Not
> even
> sure if I'm asking the right question in the correct forum (sorry if I'm
> not!)
>

Maybe it's just me, but I think you need to think this through a bit more.
Why do you need this query to "run an asp page unattended"? It's not going
to show the data to you until you go and visit the page anyway, right? So
why have it "run unattended" instead of just having the page display the
changes you're looking for?


J
jwcrosbyAuthor
Participant
September 3, 2008
Some additional information will be helpful...The database allows users to post dated announcements. When posting they enter an begin post date and an end post date. When a new entry is written to the database, it looks at the begin post date and if it is today's date, it sends an email announcement to everyone in the group. (It's basically a notification that a new announcement has been posted.)

However, if someone enters an announcement with a future post date, no email notification is ever sent, since it's programed to only check the post date upon submission (comparing it to that day's date). I'd like a routine that once every day queries the database looking for post dates that match that day's date and then sends out an email notification.

Did that clarify it any?

Jerry Text
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices