On Jan 4, 2008 8:14 AM, Chad Gray <[EMAIL PROTECTED]> wrote: > If I delete the row then I break the joins in the database. So I want to > blank the data out rather then remove the entire row.
I think Randy's got the best suggestion of just flagging the record 'inactive' or 'deleted' (or whatever label you choose to apply). but on a related note... if the JOINs are the only reason you want to keep the record... you might want to consider using OUTER JOINs. sounds more appropriate for this case. But having said that... i'd still go Randy's route and just add a boolean or bit field for "active". -- "Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter." - Dave Barry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
