Hello alltogether Does anyone of you have "the best" solution for getting a tree structure out of a table by using only one query? I mean a simple tree structure only using a Parent-ID - and not a tree set up by using graph theory (e.g. see http://www.intelligententerprise.com/001020/celko.shtml)
I still use this CF_tree-Tag, but with bigger amounts of data it gets very slow. So what I need is a quick SQL statement which gets me the nodes on level 1 sorted by data and all the other nodes sorted by ID (so the logical structure keeps alive). Also as I saw in the manual, there seem to be functions within Transact-SQL which deal with tree structures ... Any hint or idea will be appreciated - also general hints on how to handle tree structures ... to be honest for years I am looking for better solutions .. Regards Thomas http://www.internetmanagement.ch ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
