Scope query result set in a session scope

Explorer ,
Jun 05, 2015 Jun 05, 2015

Copy link to clipboard

Copied

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

Views

287

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 06, 2015 Jun 06, 2015

Copy link to clipboard

Copied

LATEST

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>

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines