> If you don't choose to add those fields(I recommend you follow S. Isaac's > method which is actually something from a guy named joe celko for which > you > can search google for) then you can do a udf in cfMX which calls a query > which calls itself for each child. Or in cf5, you have to write a custom > tag that calls itself. Either way, this recursive stuff is fairly hard on > the server whereas Joe Celkos method is very efficient if a bit more > confusing. DRE
what do you know ... http://www.mvps.org/access/queries/qry0023.htm Although this is on an MS Access site. Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
