I am attempting to set up a 3 tier category structure for a product catalogue.
i.e there sould be a parent category - Cars, then a subcategory - sedans, and
then a sub-subcategory - Fords.

These categories would all be in the same table and the relationship would be
defined by a field called parentcatid. So the fields would be catid,
categoryname, parentcatid.

The thing I need help with is the SQL query and the cf code for the nested
grouped cfoutput.

Cheers,

Steve (AKA Ken Oath) (Sydney)