> I'm joining a few tables and grouping them by their "package".
> It works great until I try to add an ORDER BY price statement
> to the sql. When I do that, it creates several groups. The
> pricing order takes precedence over the grouping done in CF.
> How can I order by price and stay within the groups?
You're lucky it's working now - it's purely coincidental that the natural
sort order matches what you're GROUPing by. You should always ORDER BY the
field by which you want to GROUP in your CFOUTPUT. If you want to specify a
secondary ordering, ORDER BY that field as well:
ORDER BY Package, Price
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
