I've always done sorting in the query or sp, by adding an "order by" clause.
If I need a special ordering then I usually add a "sort order" column where I plug in numbers to order it on. If I'm doing paging then I pass in an offset, too. Jeff Polaski Webmaster Office of Research Office of Graduate Studies University of California, Irvine http://www.rgs.uci.edu/ 949.824.6363 -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 10:35 AM To: CF-Talk Subject: Re: cfstoredproc vs cfquery ok... question. i have always used a stored proc to initally grab my data set. but then use cfquery to re-sort the data as well as page though it.. i am not that quick at dba stuff, but is the way you guys do it? or do you pass your sort orders & paging back to the proc.. thx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4