Hierarchical Recordset HELP!
Posted on 2006-11-24
Hi! I am inexperienced with creating hierarchical recordsets and need some help with creating the SQL statement.
I need to display a product catalog in ASP. My db structure (simplified) is below:
dt_PRODCAT (Used to map multiple categories and products)
I am having trouble getting my head around the subcategories. With this structure it is possible to have an infinite number of category nestings, through the use of the PARENTCATEGORY_ID field that points back to the dt_CATEGORY table.
Can someone please provide me with code to create the ADO hierarchical recordset, and code to display it also please?