Message Board Recursive Thread Delete

				
Recursive Thread Delete
Hello! Let's get started. I promise this tutorial won't be boring. You may 
enjoy yourself! Also, let me stress that this probably isn't the most efficient 
method in the entire world. Based on my debugging and testing, it seems to work 
with minimal pain, but then again I only used 15 or so records to test.
Notes: 
> I used a DSN called 'fspace', or "friendspace," for a message board I am 
programming. Also, it's more of a journal-entry interface, so "CommentID" is 
used as opposed to MessageID.
> This code hasn't been tested with massive message board systems, but if you 
end up using it, please let me know how it fairs. :)
Let's begin by the data structure. I am using this:
CommentID    ParentID    Data 
(subject, message, etc.)
The CommentID is the individual message ID, an AutoNumber.

The ParentID should be set to "0" for top level threads, and the 
CommentID of a parent if it is a "reply"

Any additional data is not used, as we only need these two values 
for deletion purposes.
This code will basically start with the top-level CommentID you wish to 
delete. Let's use this table for example,

 

 
CommentID
 
ParentID
 
Subject...
 
 

 
1
 
0
 
Topic 1
 
 

 
2
 
0
 
Topic 2
 
 

 
3
 
2
 
Re: Topic 2
 
 

 
4
 
2
 
Re: Topic 2
 
 

 
5
 
3
 
Re: Re: Topic 2
 
 

 
6
 
5
 
Re: Re: Re: Topic 2
 

The code will take the CommentID we wish to delete, for example, "2".

It will remove 2 and then search for anything has 2 listed as a "parent", 
in this case: 3 and 4.

The code then creates an "array" (Split is used to parse it) of the returned 
values, 3|4 and then cycles through each, first deleting record 3 itself, 
and then searching for anything with 3 as a child (5). The 
code will then cycle through using 5, and then later using 6. 
After there is nothing more related to 3, the code does the same 
thing for 4.
Hope this code helps :) Please give me any feedback and/or suggestions, as I 
should be posting this "friendspace" project online soon :)