Glad to help. Based on a sentatnce in your response to James' email ["I'm thinking if everything were grouped right in the SQL to start with, I wouldn't have these problems."], I wanted to point out that for a CFOUTPUT GROUP loop to work correctly, it's the ORDER BY clause of your SELECT statement that has to be right. The rest (aside from the columns returned) is completely irrelevant to the CFOUTPUT. In other words, a grouped CFOUTPUT will behave correctly if and only if the rows in the recordset are ordered correctly. It doesn't care how they're created (single table, joins, aggregate values, subqueries, etc), they just have to be in the right order.
cheers, barneyb On 12/6/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > Barney, > > This explanation did it for me! Thanks a ton! > What I needed to do was add a MAX() and MIN() to the SELECT.After all, I'm > just hunting for the lowest and highest price to display. > Then GROUP BY everything but those. My mistake was trying to GROUP BY just > one thing, or GROUP BY *EVERY*thing. > > Works like a champ! > > Thanks much, > Will > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226363 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
