delete / approve sprocs
I'm creating a new module and using the book as a guide. I'm at the point where I'm writing my stored procedures.
In the past when writing procedures that affect a single record (like update and delete sprocs), I have passed in the record's primary key value to identify the record. In the book, both 'entryID' and 'moduleID' are passed in. Does the ModuleID have to be included for the cascading delete in the modules table to work? Or could it safely be omitted from the 'ApproveGuestbookEntry' and 'DeleteGuestbookEntry' sprocs?
I don't want to omit the moduleID now and have a 'gotcha' moment later.