Hi, I think that the information you gave is not enough. In the case you have, recursion might work. But adding levels to tables is a good thing you can do, if you have a limited number of levels, other wise resot to recursion.
nabil -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:05 PM To: ActiveServerPages Subject: a simple navigation bar Hi, I'm making a small on ligne catalog app, with multiple categories. i would like to build a little categorie navigation bar, like when navigating in yahoo, between different categories. here is an extract of the table i use ID_Categorie Categorie_Desc ID_Parent_Categorie 1 Root 0 2 Phone 1 3 Tele 1 4 Wireless 2 5 DVD 3 6 Tape 3 so if i was in 'Tape' i would like to have something like this: Root>Tele>Tape so far i have just comeup with a routine that opens and close a recordset as many times as there are levels so in this case it would open/close 'rs' 3 times, but this is going to get to realy big numbers quite soon. Thanks for your time. Tim (Sorry if this got posted twice) --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
