> -----Original Message----- > From: Ali [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 20, 2008 3:26 AM > To: CF-Talk > Subject: Re: How to sort columns and Group them at the same time > > That's true. UserID is unique and makes everything else in ORDER BY > useless but what should I do? Cause group in cfoutput needs UerID.
Have you tried just making UserID the last column sorted? Remember that "ORDER BY" will sort items in the priority given - currently it would sort by DogID then by UserID then by DogPurchWaitDate then finally by desc. Put the most variable/random column of information last in the list. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
