Hi,
In Chapter 5, when a category is deleted through the website admin page, the related articles for that category are also deleted. I can't seem to find the code that deletes these articles, however. Am I missing something?

Cheers,
Simon

The articles are automatically deleted through SQL in a process known as cascading delete. When a relationship is set up between two tables an option can be specified to do a cascading update and/or delete. That means that anything that is requested to be done to the parent table is first cascaded to the child table(s). This can be very handy when you have a complicated database structure. Without cascading delete a table can have a child records that are orphaned and inaccessible.

Thanks MythicalMe, this helped me a lot and it's working on my website now, too.
I eventually found a reference to this on p.246 saying it is set up in the tables using database diagram. Is this the usual way of setting up cascading deletes? I haven't used them before.

Regards,
Simon

A stipulated yes. Anytime you can let SQL server take some of the workload your application is going to perform better, however, like most applications, it depends on the specific case. One time that you might not want to use cascading delete is when a child table has two or more parents.

Thanks once again MythicalMe, you have been very helpful.