passing recordset to next page?

[Monie]

How can i set a session to one of my recordset..?

PAGE 1

Code: Select all

<%
Address = <%addressRecordset%>
Session ("address")= Address
%>

In the next page i want to display the value...
PAGE 2

Code: Select all

<%response.write Session ("address")%>

i know this code does not working,
i just want to show what is my idea,
can anybody help me?

[spinal007]

1. a record set is an object so you'd have to use the "Set" keyword. i.e:

Code: Select all

 Set Session("address") = addressRecordset

2. I'm not sure you can store objects in your session variables (recordsets anyway).
what you should be doing is passing the "source" of your recordset to the next page. you can then use that to "re-open" your recordset.