Hi all,



Could anyone provide any tips/sample code on how to store and subsequently

re-traverse SQL queries as Session variables. Storing is not a big problem,

it's just that re-opening and getting the records at a later stage is

proving fairly awkward.



All help gratefully appreciated



SamK

> Hi all,

> 

> Could anyone provide any tips/sample code on how to store and 

subsequently

> re-traverse SQL queries as Session variables. Storing is not a big 

problem,

> it's just that re-opening and getting the records at a later stage is

> proving fairly awkward.

> 

> All help gratefully appreciated

> 

> SamK

> 

> 



Hi, could tell me why exactly u cannot retrieve data from the database?

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C0CC02.21408010

Content-Type: text/plain;

	charset="iso-8859-1"



Do not store recordsets in a Session! your KILLING your performance. If you

must use the session- and you never should - store an array by using a

.getrows on the recordset.



The whole "reopening" thing isn't happening- once the recordset is at the

session level, it's always open - just sitting there eating up resources,

connections, and so forth.





Hal Levy

StarMedia Network, Inc.

Intranet Development Manager



-----Original Message-----

From: SamK [mailto:sjkirky@b...]

Sent: Tuesday, April 17, 2001 9:58 AM

To: ASP Databases

Subject: [asp_databases] Recordsets as Session variables





Hi all,



Could anyone provide any tips/sample code on how to store and subsequently

re-traverse SQL queries as Session variables. Storing is not a big problem,

it's just that re-opening and getting the records at a later stage is

proving fairly awkward.



All help gratefully appreciated



SamK







---

SoftArtisans helps developers build robust, scalable Web applications!

Excel Web reports, charts: http://www.softartisans.com/excelwriter.html

File uploads: http://www.softartisans.com/saf.html

Transactional file management: http://www.softartisans.com/saf1.html

Scalability: http://www.softartisans.com/saxsession.html

ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html




$subst('Email.Unsub')