Well that is the problem. There are so far over 40K records, and if the user does not pick anything at all, then they get all of the records. So it could be as small as one record or over 40K.
On 1/26/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > > What is the best way to do dynamic sorting? I have a > > recordset that has several columns, and the title row is a > > link that sends a URL parameter Sort with the sort variable. > > Specifically what should I do with the query results. Should > > I cache the results so I can use it each time they click on a > > sort link? > > If your dataset is relatively small, your best bet in many cases might be > to > do it client-side, with JavaScript/DHTML. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
