recordset 오픈 여부 > ASP

The State property can have a combination of values. If a statement is executing, this property will have a combined value of adStateOpen and adStateExecuting.

1. adStateClosed value=0 The object is closed
2. adStateOpen value=1 The object is open
3. adStateConnecting value=2 The object is connecting
4. adStateExecuting value=4 The object is executing a command
5. adStateFetching value=8 The rows of the object are being retrieved

To check if a recordset is open you can use

if rs.State=adStateOpen then

end if

to close it if its open the use

if rs.State=adStateOpen then

rs.Close

end if