smcculloch posted on August 02, 2005 17:13
When coming up with the hierarchial albums for Simple Gallery, I
usually tend to stick with what has worked before in regards to
retrieving data from Sql Server in a hierarchial format.
The format I use is a recursive procedure as shown
here.
DotNetNuke uses a different model and stores them with an associated
level. There are also many other methods such as storing Depth/Lineage
as discussed
here.
Which method do you use?