Scope query result set in a session scope

[Abdul L Koyappayil]

Can any one help me out giving a good example to understand when should I scope a query result sets in a session scope.

‌

[BKBK]

In the context of session storage, there is nothing particular or special about a query result-set. You should apply the same considerations as you would for any other variable you wish to store in session scope:

- Does the variable have a value that is distinct per user?

- Is the user uniquely identified by his or her session?

- Is it necessary for Coldfusion to store the value of the variable for the particular user across multiple requests?

If so, you could define the result-set as follows:

<cfquery name="session.myQuery">

</cfquery>