> I want to be able to support an infinite amount of sub > categories, which is where the real problem lies.
Possibly you could just use a key field for each record like this maybe: Record 1: "01" (Main cat) Record 2: "0304" (sub cat 4 of main cat 3) Record 3: "02010107" (sub-sub-sub-cat 7 of sub-sub-cat 1 of sub-cat 1 of main cat 2) Then just order by record ID. When you retrieve the records you just check the length of the key to know how far into the hierarchy it goes, how many <tab>s to put in front, whether you need a category break... Bj ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
