says record closed ..BUT..

Results 1 to 2 of 2

Thread: says record closed ..BUT..

  1. #1
    Join Date
    Dec 1969

    Default says record closed ..BUT..

    I have the following code.<BR>Set oConn = Server.CreateObject("ADODB.Connection")<BR> strTemp <BR> sSql = "sp_SelectcourseInfo " & CourseID<BR> Set rsDesc = oConn.Execute(sSql) <BR><BR>Now somewhere in my code I have <BR> &#060;% If Not rsDesc.EOF then<BR> Do while Not rsDesc.EOF <BR> Response.Write rsDesc(0) &#039;line 110<BR> Response.write rsDesc(1)<BR>%&#062;<BR>But I get error <BR>Error Type:<BR>ADODB.Recordset (0x800A0E78)<BR>Operation is not allowed when the object is closed.<BR>says the error is on line 110 <BR><BR>Any idea??<BR>Please help me ! thanks!!<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: says record closed ..BUT..

    &#062;Now somewhere in my code I have <BR>maybe somewhere in YOUR code you have a rsDesc.close or something that destroys the object.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts