If you receive this error
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
you will need to check the state of the recordset as in the code below before you access any properties of the object
if not oRs.state <> 1 then
if not oRs.eof then
if oRs("Value").Value > 0 then
myval = oRs("Value").Value
else
myval = 0
end if
end if
else
Response.Write "Cannot find any records"
end if
Subscribe