Some good thoughts, Isaac. I haven't built any blogging or forums tools so everything so far has required referential integrity.
But when I do get around to some blogging tools, which I plan to, I'll definitely keep your perspective in mind....good stuff to know. Rick -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, April 01, 2006 11:57 PM To: CF-Talk Subject: RE: Anything inherently wrong with this query? > Thanks for the explanation, Isaac! Also just FYI, although referential integrity is desired in most cases, there are some exceptions in which you may not want to enforce referential integrity. Typically the only place you would want to allow orphaned records would be in a logging tool or in a record which is representative of some sort of log like a blog comment. This allows you to maintain a log entry for an event, even if the log references a deleted user. The act of deleting the user doesn't alter history, so you still want to retain a record of the event. ....message truncated... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
