Mailing List Archive


Back to the month index Back to the list index
Joshua J. Kugler (jkugler@inreach.com)
Wed, 09 Apr 1997 16:13:28 -0700 

Message-Id: <3.0.1.16.19970409161328.2e0f3476@inreach.com>
Date: Wed, 09 Apr 1997 16:13:28 -0700
From: "Joshua J. Kugler" <jkugler@inreach.com>
Subject: Re: [mSQL] Automatic Delete

> Could anyone tell me whether it is possible to delete data from the
>database by setting some kind of time limit on the time the data is
>stored in the database?

As far as I know, I don't think so, because mSQL doesn't have a 'date'
field type.

What you could do is put the date, e.g. 04/09/1997 in a field when a record
is added. Then you could write a script that would cycle through the data,
splitting those elements in to three variables, then do something like:

If (month < 5 AND day < 10 AND year = 1997)
   {delete where unique_id_field = $unique_id}}
elsif (year < 1997) {delete where unique_id_field = $unique_id}

Using this 'code', the example record entered above would be deleted, as
would all records entered prior to April 10, 1997.

As splintered as that is, I hope it helps!

j----- k-----

Joshua J. Kugler
Computer Consultant--Web Developer
jkugler@inreach.com
http://www.cwebpages.com/jkugler
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth, that Jesus Christ is LORD -- Count on it!

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!