Reusing a Result Set

[_andyK]

Hi,

Lets say I have the following:
<cfquery datasource="#data#" name="getData">
Select * from emp
</query>

Within the page I can use this relsult set. I want to eliminate haveing to
rerun the same query.
Is there a way I can store thie result set and access in another form ?
ex:
<cfset session.query.ids = getData>
Then use cfoutput etc to retrieve this data?

Thanks

Andy

[mxstu]

If you mean access the results on another page, one option might be to store the query results in a session variable. However, this may not be the best option if the resultset is large.

[_andyK]

Hi,

think that I found the solution. Cahe the query then use query of queries to
resort the results as needed.

<cfquery cachedwithin="#createtimespan(0 0 15 0)#" name="mainRS">
exec ....

</cfquery>

then

<cfquery dbtype="query" name="differntsort">
select * from mainRS where ....

</cfquery>

This should work.

The thing I have to find out is how much memory to allocate.

Thanks

Andy

[BKBK]

createtimespan(0, 0, 15, 0)

[_andyK]

Thanks for all of the help


Andy