Here is the secret language I was looking for... #ChildName[CurrentRow]# I needed to understand how the grouping actually worked in order to know what syntax I could use to access the "CurrentIndex" of the query.
~Jason -----Original Message----- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:15 PM To: CF-Talk Subject: RE: group by in cfoutput It does a portion of what I want. I need to restrict the output of the group by to a max of 3 records per parent category. ~jason -----Original Message----- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:11 PM To: CF-Talk Subject: Re: group by in cfoutput look at the group attribute of cfoutput. Should do what you want. HTH, Sam ----- Original Message ----- From: "Dowdell, Jason G" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 2:30 PM Subject: group by in cfoutput > Hi all, > > Here's a bit of a challenge. I have a single table storing category > information similar to any search engine. The table structure looks > like this > ID Name ParentID Level > 1 Computers 0 1 > 2 Laptop 1 2 > 3 Desktop 1 2 > > Since I have to display this information I must join the table back to > itself. All joining has gone fine :) My problem is in the display of the > information to the users. I want to display the Parent category > and then only 3 children from each category. Sounds easy but > I'm not sure if I can do this in sql or not. If sql could accomplish > this then super, if not then it's a good CF challenge. > > Any ideas? > > > ------------------------------------------------- > Jason Dowdell > IM-AES Web Developer > 321.799.6845 > [EMAIL PROTECTED] > ------------------------------------------------- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm