关于在Sub里使用记录集的问题,遇到几次了,求解决办法?
具体情况如下:
写了一个函数:
<%
Function SecVal(BoardID)
Dim rs_security,sqlstr_security
Set rs_security = Server.CreateObject("Adodb.Recordset")
sqlstr_security = "SELECT * FROM Net_User WHERE UserID="&CInt(UID)
rs_security.Open sqlstr_security,conn,3,3
If rs_security.Eof OR rs_security.Bof Then
RsClose
ConnClose
Response.Redirect "ShowError.asp?errid=0"
End If
Call CHKBalance(rs_security("UserGroupID"),rs_security("JoinDate"),rs_security("UserBalance"),rs_security("TotalTime"))
'关闭记录集,这里出了问题
RsClose
End Function
%>
<%
Sub CHKBalance(GroupID,JoinDate,Balance,TotalTime)
Dim UseDays
Select Case GroupID
Case 1
Case 2
Case 3
Case 4
Case 5
End Select
End Sub
%>
<%
Sub RsClose
rs_security.Close
Set rs_security = Nothing
End Sub
Sub ConnClose
conn.Close
Set conn = Nothing
End Sub
%>