Passing RecordSet between ASP-pages

[J]

Hi!

I want to pass a RecordSet between two asp-pages. Is this possible? If it
is possible, how do I do it?

The RecordSet contains the results from a search operation and I don´t want
to perform the search every time.

Regards,
J

[Kris Eiben]

NOT recommended. Any way you do it, you will be wasting the resources
allocated to that recordset while the user reads the page, makes coffee,
takes a smoke break, etc. And how do you know the user will actually go
from the first page to the second -- not from the first page to
www.sillysite.com?

A better solution would be to pass the parameters you used to get that
recordset from one page to the next, and re-query. Believe it or not,
this is more efficient than holding the recordset open.

If you want to _page_ records, that's different. See an example here:
http://www.learnasp.com/learn/dbtablepaged.asp

"J" <jarno.nieminen@modul1.se> wrote in message
news:3d09c829$1@10.1.10.29...
> I want to pass a RecordSet between two asp-pages. Is this possible? If
it
> is possible, how do I do it?
>
> The RecordSet contains the results from a search operation and I don´t
want
> to perform the search every time.

[J]

Ok, Thanks

/J

"Kris Eiben" <eibenkthisisforspammers@yahoo.com> wrote:
>NOT recommended. Any way you do it, you will be wasting the resources
>allocated to that recordset while the user reads the page, makes coffee,
>takes a smoke break, etc. And how do you know the user will actually go
>from the first page to the second -- not from the first page to
>www.sillysite.com?
>
>A better solution would be to pass the parameters you used to get that
>recordset from one page to the next, and re-query. Believe it or not,
>this is more efficient than holding the recordset open.
>
>If you want to _page_ records, that's different. See an example here:
>http://www.learnasp.com/learn/dbtablepaged.asp
>
>"J" <jarno.nieminen@modul1.se> wrote in message
>news:3d09c829$1@10.1.10.29...
>> I want to pass a RecordSet between two asp-pages. Is this possible? If
>it
>> is possible, how do I do it?
>>
>> The RecordSet contains the results from a search operation and I don´t
>want
>> to perform the search every time.
>
>