While we’re on the topic of good coding techniques, I thought I would remind everyone to close and free up object references once they are done using them.
I tend to type in the commands to kill the object right after I create the object, and then start coding between them.
Dim objConn, objRS
Set objConn = Server.CreateObject(“ADODB.Connection”)
objConn.ConnectionString = …
Set objRS = objConn.Execute(“…”)
Set objRS = Nothing
Set objConn = Nothing