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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
