View Full Version : Loop ADODB objects
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.
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
09-30-2005, 06:56 PM
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.
Powered by vBulletin® Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.