Re: Is there such a thing as a recursive query?? [message #22968] |
Thu, 07 November 2002 12:28 |
John Smith
Messages: 25 Registered: February 2002
|
Junior Member |
|
|
I have to make as few db accesses as possible. Therefore I took the first part oof your code and it spits out a few short rows containing only the elements involve din the path. Since it's usually only 1-3 levels deep, I just parse through the now short table and add the names together. It doesn't always stop at 1 because 1 was just an example...the real data numbers are much more complex.
Anyways, I've ended up with what I feel is a very good solution from the code/structures you gave me. Thanks so much for your help!
Take care,
J.S.
|
|
|