[thelist] one for the database gurus - recursive query
Mike Hardaker
mike at angloinfo.com
Sat Feb 24 04:42:02 CST 2001
http://www.santry.com/search/articles.asp?ID=899 covers recursion quite
nicely - and tersely.
Myself, I'd take the logic and apply it to an array that's been created from
a recordset.getrows command, 'cause this sort of recursion on an actual
recordset can thrash the server somewhat.
A real-world example of this can be seen in the hierarchical directory on
http://www.angloinfo.com/, with performance that I think is acceptably
brisk.
Cheers, Mike
-------------------
Mike Hardaker
Founder & Publisher
AngloINFO
www.angloinfo.com (Web)
wap.angloinfo.com (WAP)
More information about the thelist
mailing list