Caching and Reusing a Query Generated with QueryNew Function

[Brian Niski]

Is it possible to cache and reuse the results of a query created in the code 
using QueryNew, QueryAddRow, etc.?

My Problem:  I want to create and cache a query on Page 1 and have it available 
for use on Page 2 by other QofQs.  I cannot find a way to cache “query1” so 
I have created “query2” to cache.  I cannot however use query2 on Page 2.  
I get the error message, “Query of Queries Runtime Error.  Table named query2 
was not found in memory.”

I have successfully cached and reused queries that are generated from a 
database.

Here is an example of what I am doing that is not working.

<cfset query1 = QueryNew("id, name") >
<cfset temp = QueryAddRow(query1, 6)>
<cfloop index="i" from="1" to="6">
        <cfset temp = QuerySetCell(query1, "id", #theid#, #i#)>
        <cfset temp = QuerySetCell(query1, "name", #thename#, #i#)>
</cfloop>

<cfquery name="query2" dbtype="query" cachedwithin="#createTimespan(0,0,2,0)#">
        SELECT * 
        FROM query1 
</cfquery>

Are there any rule preventing what I seek to do?

Thanks

Brian


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309112
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4