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: