-
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 4:34 PM
To: CF-Talk
Subject: Re: Undo Delete
So I have a dba question. What is the difference between using a view
instead of a stored procedure. Now I am well aware that you cannot make
views as complex as sp's. I am
So I have a dba question. What is the difference between using
a view instead of a stored procedure. Now I am well aware that
you cannot make views as complex as sp's. I am actually wondering
what the performance or otherwise difference between making a
stored procedure which is
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
Views???
From: Dave Watts [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Undo Delete
Date: Sun, 17 Dec 2000 22:58:36 -0500
I'm thinking of changing my typical "Delete" button so that
it doesn't actually delete a record, but ra
David you must have missed my post.
a href="action.cfm" onclick="return confirm('Are you sure you want to
delete the record? If so click OK, otherwise Cancel.')Delete/a
We have a problem with this approach - quite a lot of the users on our sites
are behind firewalls which restrict the use of
Sounds like a good idea to me. Go for it!
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL:
Sounds like a good idea to me as well. On our two largest projects, we don't
let users permanently delete anything .. ever. We just flag the data that
they 'delete' to not show up any more. Inevitably, someone always deletes
something that they want back. Well, we can certainly get their data
And, if the user IS concerned with drive space, you can date stamp the
delete, thus run a batch clean up once a month to remove entries that are a
year or older : )
At 03:16 PM 12/17/00 -0500, Todd Ashworth you wrote:
Sounds like a good idea to me as well. On our two largest projects, we
I'm thinking of changing my typical "Delete" button so that
it doesn't actually delete a record, but rather flags it as
a record to be ignored. I'd also record the date/time that
it was flagged. That way I can offer the user the opportunity
to Undo the Delete. I'll probably schedule a
Thanks for all of the replies to my "Undo Delete" post. Here's a summary
(some items contradict others). Of course, further comments are welcome.
* Do a "soft" rather than a "hard" delete. That is, flag the data as
unavailable but leave it in the database.
* Timestamp the soft deletion.
*
uot; [EMAIL PROTECTED]
Sent: Monday, December 18, 2000 12:17 AM
Subject: Re: Undo Delete
Thanks for all of the replies to my "Undo Delete" post. Here's a summary
(some items contradict others). Of course, further comments are welcome.
* Do a "soft" rather than a "har
11 matches
Mail list logo
