Stephen Adams wrote:
Nightmare. If you're stuck with the parent/child adjacency model, then its a recursive process of walking the tree down each branch for children of the current record and walking back up again when you reach the end of a branch.One of the problems I have is that the database (which is Access) is already being used, so I can't make changes to it.
I am thinking of dividing the work into small pieces, using individual tags to retrieve the Title, Section, etc.
To be honest, I don't think that changing your query into a struct will help that much, as you can only get one level of children for one parent at a time. If you were able to get all children all the way to the ends of the branches in one go, then using the UDF to change your query struct of struct might provide some assistance with coding.
Sorry.........
Stephen
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
