Hi.

I have develope system which need a certain code which will perform 
database updation automatically.
A lots of member are register to my site.Those who are in trail mode needs 
to be deleted from database after their period is expire.I can do that by 
putting delete query which will compare dates of registration and expiry 
date.But for this I will need to call certain page.I need certain code 
which will run automatically at night 12.00 O'Clock and perform database 
clean up..

Please help me.

Waiting for you help

D.Ganesh

Hi

The easiest way to do this is to write a vb script(.vbs) or javascript
(.js) file.  You can then create a scheduled event to run the script for 
whenever you need it. 

As far as I am aware you can't run scheduled events on .asp files.  I 
would love to be proved wrong though.

Cheers
Darrell 

> Hi.

> I have develope system which need a certain code which will perform 
d> atabase updation automatically.
A>  lots of member are register to my site.Those who are in trail mode 
needs 
t> o be deleted from database after their period is expire.I can do that 
by 
p> utting delete query which will compare dates of registration and expiry 
d> ate.But for this I will need to call certain page.I need certain code 
w> hich will run automatically at night 12.00 O'Clock and perform database 
c> lean up..

> Please help me.

> Waiting for you help

> D.Ganesh

Why not just run the "cleanup" code whenever anyone logs in or accesses
particular (or all) pages? You can also check to see if the last "cleanup"
date is the same as the current date, and only run the update or delete
query if it hasn't run yet that day.

Also, instead of deleting the trial users, you could just "mark" them as
expired in a database field.

-- Zee


----- Original Message -----
From: "Darrell" <darrell@b...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, July 19, 2002 8:52 PM
Subject: [access_asp] Re: Automatic Database updation at 12.00 a.m.


> Hi
>
> The easiest way to do this is to write a vb script(.vbs) or javascript
> (.js) file.  You can then create a scheduled event to run the script for
> whenever you need it.
>
> As far as I am aware you can't run scheduled events on .asp files.  I
> would love to be proved wrong though.
>
> Cheers
> Darrell
>
> > Hi.
>
> > I have develope system which need a certain code which will perform
> d> atabase updation automatically.
> A>  lots of member are register to my site.Those who are in trail mode
> needs
> t> o be deleted from database after their period is expire.I can do that
> by
> p> utting delete query which will compare dates of registration and expiry
> d> ate.But for this I will need to call certain page.I need certain code
> w> hich will run automatically at night 12.00 O'Clock and perform database
> c> lean up..
>
> > Please help me.
>
> > Waiting for you help
>
> > D.Ganesh