ASP Recordset Passing

[dcarlson]

Is it possible to pass a recordset from one page to another or can you only do it using a session variable?

[Ianpbaker]

Unfortunatley all asp pages are stateless, so you can't pass object's between pages. The best way to get around this is to either pass the SQL string to the next page and or the Primary key of the field so you can get to that field in your new page.

Hope this helps

Ian

[dcarlson]

The reason why I would like to pass a recordset is because I build it from scratch and it's disconnected from the database. I use it for a Report in Crystal. I ended up just putting it in a session variable.

Thanks,

[monte96]

Crystal pretty much requires you to use the Session Object for recordsets as well as it's oApp and oRpt objects. If they aren't there and you are using their rptserver.asp page, it simply will not work and you will end up wasting ALOT of time trying to figure out why. You can't even choose the name, it must be session("oRS"). (Unless of course you modify the rptserver to allow another name which would probably not be worth the effort)