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:258051
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
