Re: FN-FORUM: Suggestions please

date posted 15th August 2003 16:17

It is MYSQL. That is a good idea of yours of having a date on the database.
Thanks - I think I might do that - Pam
----- Original Message -----
From: "David Turner" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, August 15, 2003 4:36 PM
Subject: RE: FN-FORUM: Suggestions please


>
> - stored procedure that gets called once a day?
> - do what you are doing, but set a datetime property in your datebase when
> the task has been completed, then only run the cleanup if the datetime
flag
> > 1 day from current_date() (this is not a very neat solution, as the
check
> will be made at every login )
>
> i would have thought the easiest solution will depend upon the RDBMS you
are
> using.
>
> rather than deleting the data, it might make more sense to archive it off
to
> another table, that way if somebody says have you got the time sheets for
> mrs miggins for 1987....
>
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of PAMELA
> WHITTAKER
> Sent: 15 August 2003 16:16
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: Suggestions please
>
>
>
> Hi,
> I am writing a timesheet at the moment and I want to make sure that
> noting over 5 years old is kept on the database. The only way I can think
of
> is going through and deleting everything over five years old every time
> someone logs in to the system which could be more than once a day.
> especially on a Friday. Can anyone think of a way of only doing it once a
> day please.
>
> Thanks
> Pam
>
>
> '
>
> NTMail K12 - the Mail Server for Education
>
> ==========
> redmail.com - webmail with a difference!
> 10Mb for just GBP 9.99 a year. Launch special 1Gb for GBP 99.99 a year
> IMAP, POP3, Spam Filtering and Anti Virus as standard.
> Visit http://www.redmail.com/?fl-signup to join.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> ==========
> redmail.com - webmail with a difference!
> 10Mb for just GBP 9.99 a year. Launch special 1Gb for GBP 99.99 a year
> IMAP, POP3, Spam Filtering and Anti Virus as standard.
> Visit http://www.redmail.com/?fl-signup to join.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>