...

View Full Version : Loop ADODB objects



dominicall
09-30-2005, 04:34 PM
Anyone know if this is possible?

Is there a method when page execution has finished in ASP to test whether any ADODB objects are still open and, if so, to loop through the open ADODB objects?

That way I can close them making sure I'm not leaving any open.

Thanks

Dominic

hinch
09-30-2005, 04:50 PM
something like (dont hold me to this)



for each strItem in ServerVariables.ADODB


ofc you could just make sure you manually close each record set after you've finished using it

and then just at the bottom of the page close the connection and object.
since in reality you only ever need one connection object and just multiple record set's

if i can find the correct variable i'll post it in abit

dominicall
09-30-2005, 06:56 PM
Thanks hinch

I'm normally pretty religious about closing recordsets, connections, etc... but wanted to see if there was a fallback that would do a final check and close anything that was open.

Will give that a go and refer to my ServerVariables notes.

Dominic



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum