Ok... and I can set the argument in the cfc to default to a order that is common for the data.
Then if I need a different order I will pass it to the CFC. Makes sense. Guess I was getting lazy here at the end of the day. Thanks Charlie! > -----Original Message----- > From: Charlie Griefer [mailto:[email protected]] > Sent: Tuesday, March 03, 2009 4:19 PM > To: cf-talk > Subject: Re: order query object > > > On Tue, Mar 3, 2009 at 1:10 PM, Chad Gray <[email protected]> wrote: > > > > > Say I have a CFC that returns a query object. > > > > When I go to output the data can I sort the query object on the display > > page? > > > > This way I don't have to have an ORDER BY in the SQL in the CFC. I > could > > do the order by or sort when I go to display the query results instead. > > > > why not pass the sort order in as an argument to the CFC method? > > if you really wanted to, you could do a QoQ on the display page to sort. > But I'd think that returning the query in the "proper" order (the order > in > which the display page wants to use it) would be preferable. > > -- > I have failed as much as I have succeeded. But I love my life. I love my > wife. And I wish you my kind of success. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
