Forum Moderators: open

Message Too Old, No Replies

Closing connections and objects

recordset, objects, connections, close

         

geostant

3:10 pm on Mar 19, 2004 (gmt 0)



I got a small project to do,
I have a bunch of ASP pages that in all of them there is a use of RS objects, the problem that in most of them there is a missing line to close these objects.

Is there a nice few lines code that I can include in all the ASP pages to check wherever there is still open objects and that this include will close them?

Thanks

txbakers

6:02 pm on Mar 19, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



rsRecordSet.Close()

just add that at the bottom of each page.

trg9

9:40 pm on Mar 19, 2004 (gmt 0)

10+ Year Member



try this:

If Not (Rs Is Nothing) Then
Set Rs = Nothing
End If