i ended up doing a second query for the child items inside the <cfoutput> of the query for the parent items.
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Dave Phipps <dave@phipps- To: <[EMAIL PROTECTED]> cf.co.uk> cc: Subject: Re: [ cf-dev ] outer self join 02/20/03 08:21 AM Please respond to dev I have just had to do a similar thing with a navigation system where menu items could be parents or children. I have yet to find a query that can do it all in one. The best I have found is the <cf_buildtree> custom tag. This is a recursive tag. The article is in CFDJ:Volume 2 Issue 10. If you want me to send you the tags off list then let me know. Also if you find a way to do it without using a recursive tag call then let me know. Cheers Dave At 14:42 2/19/2003 +0000, you wrote: >isn't that just for use with Aggregate functions? If not, how'd you see it >being used in my query? > > >Duncan Cumming >IT Manager > >http://www.alienationdesign.co.uk >mailto:[EMAIL PROTECTED] >Tel: 0141 575 9700 >Fax: 0141 575 9600 > >Creative solutions in a technical world > >---------------------------------------------------------------------- >Get your domain names online from: >http://www.alienationdomains.co.uk >Reseller options available! >---------------------------------------------------------------------- >---------------------------------------------------------------------- > > > > > "Taz" > > <chris@cfmast To: > <[EMAIL PROTECTED]> > er.co.uk> cc: > > Subject: Re: [ cf-dev ] > outer self join > 02/19/03 > > 02:37 > PM > > Please > > respond > to > > dev > > > > > > > > >You'd probably get more success with a HAVING clause. > >Taz > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > > > > > > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] ============================================ Phipps CF Development Oxford, Oxfordshire. Telephone: +44(0)7718 896696 http://www.phipps-cf.co.uk ============================================ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
