Newbie need help with a query

[Zoom1177]

I've got a table, here is an example

expertise excode
=================================
Building types 01000000
education 01010000
k-12 01020000
construction 02000000
substructure 02010000
foundations 02020000

i would like to pull a dynamic menu from the last table to put it on my ASP. Of course the table has more records.

Now the final results should be categorize according to each category code
so Building types: should have under neath it (education and K-12) as they both belong to the 01 code

Construction should have under neath it (substructure and foundations) as both belong to the 02

It has to be dynamic (loop with variable not numbers), because the categories will increase in the future.

any ideas?
Thanks in advance

 

[r937]

why must each category be in its own result set???



r937.com | rudy.ca

 

[Zoom1177]

It's the way you can design the ASP

There is something called "Repeat Region" in ASP (active server pages) if i put all the result in one set how the Menu will know which category is the parent and which is the child and which is the end child???

I must put them each in different result set so on the ASP i can just select the partent assign it to the outer node and hit the "repeat region" feature it will show each parent on each OWN tree node and i did it in a real ASP and it worked...but only for the outer nodes (those 5 categories)

 

[r937]

perhaps you might wish to start a new thread in the asp forum

a good asp programmer should be able to return the entire hierarchy table in one query and break out the subcategories while looping through the result set

i'm a coldfusion guy myself, and in coldfusion, it's pretty simple

r937.com | rudy.ca

 

[Zoom1177]

I might do that

thanks for your help all