It's possible and it's also a good way to kill your server. Think of how much memory it would take to store a single record set in session. Now think of how many sessions you have on average. Finally, picture how much memory it would take for 10% of those sessions to store large amounts of data in memory. Even 5%.
You really need to do all of this on the database and only bring back bits of the data to CF. Store the original query parameters in a session variable -maybe-, and then send them and additional parameters to the database. Picture the first query as SELECT * FROM bunchaTables WHERE a = b AND c = d Then "search within these results" looks like SELECT EXPR1.* FROM ( SELECT * FROM bunchaTables WHERE a = b AND c = d ) AS EXPR1 WHERE EXPR1.columnA = e AND EXPR1.column2 = f all of this data gets filtered on the database and you just bring back n records at a time to CF. Make sense? -- Adrian >I have a large amount of data returned from a database using a query and I >write it to a session. Now I want to query that session results much the >same way as you would do a query of Query. > > > >Isn't this possible? > > > >I want to build a "Search within these Results". > > > >Thanks. > > > >Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:313284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
