|
ASP Commandment #5: Clean Up Objects
Close each object when done with them. This frees up
the "handle" to the resource. This applies to objects that support close
methods, especially connections and recordsets!
Set each object variable to nothing when done with it.
this frees up the memory devoted to the resource and/or returns it to the resource
pool.
The code sample below makes a list box from a database.
Notice the close and set to nothing at the end of the code. NEVER forget it in your code.
filename=/learn/test/dblist.asp
<html><head>
<TITLE>dblist.asp</TITLE>
</head><body bgcolor="#FFFFFF">
<%
myDSN="DSN=Student;uid=student;pwd=magic"
mySQL="select author from authors where AU_ID<100"
' displays a database field as a listbox
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
set rstemp=conntemp.execute(mySQL)
if rstemp.eof then
response.write "no data for<br>"
response.write mySQL
conntemp.close
set conntemp=nothing
response.end
end if
%>
<form action="dblistrespond.asp" method="post">
<Select name="authorname">
<%
' Now lets grab all the data
do until rstemp.eof %>
<option> <%=RStemp(0)%> </option>
<%
rstemp.movenext
loop
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
%>
<input type="submit" value="Choose Author">
</Select></form>
</body></html>
|