<http://www.foxytunes.com/artist/bassdrive+-+music+beyond/track/24+7+drum+and+bass+jungle+radio+featuring+live+shows>On
9/13/07, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
>
> ?
>
> ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
Instead of
<cfquery datasource="dsn">
Delete from table where id = #id#
</cfquery>
I use
<cfquery datasource="dsn">
Update table set IsDeleted = 1
where id = #id#
</cfquery>
IsDeleted or isActive is an extra column I create in all of my tables.
The all of my database extractions have an extra and statement in them.
<cfquery datasource="dsn" name=rsGetRecords>
Select cols from table
Where id = #id#
and IsDeleted = 0
</cfquery>
I've found that even with the javascript popup box, people still continue to
delete records they really want. This is a sure fire way to become the hero
when they call wondering if there is a way for you to restore something they
deleted. You might be able to get this record from a backup tape but this
would be a great deal quicker.
Casey
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288465
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
