Agreed. Just be careful of how large the result sets may be. If you begin storing tens of thousands of records in memory for hundreds of users, your JVM heap might start growing like crazy. It shouldn't be a problem on a smaller scale, though.
~Brad -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 25, 2006 2:29 PM To: CF-Talk Subject: RE: Query of Query There's nothing wrong with what you are saying, other than it is not all that clear. But yes, you can refine searches stored in memory. Heck, you can even name them the same thing. Let's say you have a query in memory names SESSION.UserSearch... And you want to refine it, you should be able to do: <cfquery name="SESSION.UserSearch" dbtype="query"> SELECT [columns] FROM SESSION.UserSearch WHERE date_created > [criteria] </cfquery> This takes the SESSION.UserSearch query in memory and basically over writes it with a query of queries on itself. ....................... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -----Original Message----- From: Ken [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 25, 2006 3:25 PM To: CF-Talk Subject: Query of Query Hi. I want to hold the results of a query in a session variable, and then when the user has gone couple of pages further, I want to refine the search by doing a Query of Query on the previous query held in the session. Is this method ok, or can anyone suggest a method to do refined searches? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
