Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Fast interactive re-selection using filter method


Message #1 by "William Milne" <wmilne01@e...> on Tue, 11 Apr 2000 15:4:9
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.)


  Return to Index