Just like an audit trail.
>From: Michael She <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: OT: Undo Delete
>Date: Sun, 17 Dec 2000 02:04:33 -0500
>
>Hello,
>
>
>I do this for my message forum where I flag deleted posts. This way, I can
>recover the posts if neccessary in the future (ie law suit against me! : )
>
>Another possibility is using your "approved field" and making it a
>text/numeric flag instead. This way you can have mutliple states (A for
>approved, D for deleted,etc) however I don't know if that is good practice.
>
>At 06:51 PM 12/16/00 -0800, David Shadovitz you wrote:
>
> >Any thoughts?
> >
> >Here's another use for flagging records: Our db tables which contain
> >scientific data contain an "approved" field, whose default value is
> >"false". After data is inserted into the database, an analyst checks it
> >out, and then we toggle the flag to "true". Of course, our non-admin
> >canned queries all include "WHERE approved = true".
>
>--
>Michael She
>I m a g i n e C o m m u n i c a t i o n s
>Company E-mail: [EMAIL PROTECTED]
>Personal E-mail: [EMAIL PROTECTED]
>ICQ UIN: #243466
>Personal Homepage: http://www.michaelshe.com (Under Construction)
>Imagine Communications: http://www.imagineer.net
>PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
