Killing Unknown Recordsets

[NWChowd]

Is there a way to set multiple recordsets = nothing when the name of the recordsets (rsFake, for example) is not known ahead of time? In other words, I would like to create one include at the bottom of many pages whose sole function is to close all recordsets on that page and set them all = nothing to free up memory resources. I believe this is possible in VB6, but how can it be done in ASP and VBScript???

Anyone have any suggestions?

Thanks,
DMill

 

[snowboardr]

I dont know if you an do them to all at one time.. but you can just do

set rsFlake = nothing
set blabla = nothing

on each one.. I don't believe there is a short way of doing that.. www.vzio.com

/

 

[snowboardr]

Ok here is a simple little tool I whipped up that does it for you... if you want the source mail me at jason@vzio.com

format is like this:

ObjText, rsFlake, rsHome
or
ObjText rsFlake rsHome
www.vzio.com

/

 

[snowboardr]

oops, the URL is

http://www.vzio.com/set.asp

www.vzio.com

/