[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