Even if you can, I suspect it's not a very efficient method. > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm