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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
