That's the piece I'm working on now. It won't allow you to do that since you must specify a query in order to specify maxrows.
~Jason -----Original Message----- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:17 PM To: CF-Talk Subject: RE: group by in cfoutput Can you put maxrows="3" in the innermost CFOUTPUT? > -----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 Get the mailserver that powers this list at http://www.coolfusion.com