Thanks for the help today, Stephen Adams Forvus 53 Clapham Common South Side, London, SW4 9BX http://www.forvus.co.uk
-----Original Message----- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 16:29 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] using custom tag CF_QueryToStruct Stephen Adams wrote: >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. > > 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. 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] ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- 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]
