Clustered environment - pass recordset to new window (popup)
I am currently working on a project (internal application) that will be hosted on load-balanced servers, and I need to pass a few small recordsets to a pop up window for some select boxes. Obviously, Application variables won't work, and Session variables have been disabled.
What is the best method, in this circumstance, of passing a few small recordsets to a pop up window? I can't run the query directly from the pop up because the query takes too long to run, directly; it's quicker to query a query that already ran in the parent window.