hi i m getting the error "Operation is not allowed when the object is closed".Why am i getting the error??Plz help


Code:

Set rs_Temp= Server.CreateObject("ADODB.Recordset") 	
Set Cmd = Server.CreateObject("ADODB.Command")
   Cmd.ActiveConnection = lcn_Temp
    Cmd.CommandType = adCmdStoredProc
    Cmd.CommandText = "sp_temp"
Cmd.Parameters.Append Cmd.CreateParameter("@strCurrDate", adVarChar, adParamInput,100, CurrEndDate)
rs_Temp.CursorLocation = 3	
rs_Temp.Open Cmd

Actually recordset is open initially .When i click on a link in that page.then the recordset closes.Why is it like this?

Hi,

Post your whole script

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.