Aditional info:
When I write the session I do this:
<cfscript>
Session.SearchResults = StructNew();
Session.SearchResults = QryGetProviders;
Session.SearchText = Form.SearchText;
Request.SearchText = Form.SearchText;
Request.SearchResults =
Duplicate(Session.SearchResults);
</cfscript>
Then I output those results
<cfoutput query="Request.SearchResults" startrow="#SearchStart#"
maxrows="10">
.......
But is I try to run a query of query;
<cfparam name="SearchBy" default="lastName">
<cfparam name="SearchText" default="smith">
<cfquery name="QryGetData" dbtype="query">
SELECT FirstName, lastName, TaxID
FROM Request.SearchResults
WHERE #SearchBy# LIKE '%#SearchText#%'
</cfquery>
I get;
Query Of Queries runtime error.
Table named "Request.SearchResults" was not found in Memory. It is
misspelled, or the table is not defined.
I also tried:
<cfparam name="SearchBy" default="lastName">
<cfparam name="SearchText" default="smith">
<cfquery name="QryGetData" dbtype="query">
SELECT FirstName, lastName, TaxID
FROM Session.SearchResults
WHERE #SearchBy# LIKE '%#SearchText#%'
</cfquery>
And got;
The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
Rick
-----Original Message-----
From: Rick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 2:10 PM
To: cf-talk
Subject: Query of Session?
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:313285
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
