I have an ASP appliction which displays lists in a 'header' frame with a
detail recordset in the lower frame page. Client side code formats the
user-selected list values into a querystring for the detail frame page,
which converts the querystring to an ADO recordset Filter expression. The
detail page is then redisplayed and the filter applied. As the database is
not being re-queried by SQL this is very fast. However I can only achieve
this by storing the recordset object as a Session variable so that it
persists between refreshes of the detail page. As this is clearly
undesirable from a scaleability viewpoint, how can I achieve the same
performance and interactive selection capabilities without storing the
object as a session variable (e.g. using a disconnected recordset. When I
try this just now I keep losing the detail recordset when the page is
re-loaded.)