Skip to main content
A
Abdul L Koyappayil
Inspiring
June 6, 2015
Question

Scope query result set in a session scope

  • June 6, 2015
  • 1 reply
  • 416 views

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

‌

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    June 6, 2015

    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>

    Firefly Community Gallery
    Adobe Firefly

    Remix with Firefly Community Gallery

    Thousands of free creations to fall in love with and remix in Firefly.

    Explore now
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices