> what is a cascading delete? In a "parent-child" data relationship, you can specify that deleting a "parent" record deletes all of it's associated "child" records. It makes sure your database maintains its "referential integrity". It also makes deleting records from multiple tables a doddle, as you just delete the parent-most record and the DBMS ripples the deletes through its children.
-- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 _____________________________________________________________________ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call ________________________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
