I need to use the same recordset on 2 subsequent ASP pages. I create it in the 1st one and close it but don't set it to nothing. It must be somewhere on the server, but where? And how do I access it again?
Of course the RS goes out of scope after the page is completed.<BR><BR>It is possible to pass the rs in a Session variable.<BR>not sure whether it would be <BR><%Session("RS") = rs%><BR>or <BR><%Set Session("RS") = rs%><BR><BR>But this is considered a bad idea because it uses too much resources. You would just need to open the rs in the next page.<BR><BR>Also whenever your open any object, you should close it and set the variable to nothing, to ensure that memory is released when you are finised with it (eg):<BR><BR><% <BR>rs.close<BR>set rs=nothing<BR>%><BR><BR>If every time you open an object you forget to do this, you will end up with no available memory, as it is not released automatically.