Highlighted

Scope query result set in a session scope

Explorer ,
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

283

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

Scope query result set in a session scope

Explorer ,
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

284

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
Jun 05, 2015 0
BKBK LATEST
Adobe Community Professional ,
Jun 06, 2015

Copy link to clipboard

Copied

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
Reply
Loading...
Jun 06, 2015 0