"soft" delete

[eluser]WanWizard[/eluser]
I capture this scenario in my models. In the delete() method I check if the table contains a 'deleted' column. If so, I run an UPDATE instead of a DELETE query.

The controller is not aware of this, it just calls the delete() method of the model. The opposite happens at retrieval, where a WHERE clause is inserted with 'AND deleted = 0' to filter out deleted records.