stored procedure record count

Results 1 to 2 of 2

Thread: stored procedure record count

  1. #1
    Join Date
    Dec 1969

    Default stored procedure record count

    I&#039;m trying to update the db by using the stored procedure and after it updates it should pass back a value whether it passed/failed. But it throws back an error stating the recordset is not open....I&#039;m drawing blanks right now...<BR><BR>set rsCheck = Server.CreateObject("ADODB.Recordset")<BR>rsCheck. Open "ict_auto_accele &#039;" & username & "&#039;, &#039;"& password &"&#039;, &#039;&#039;", dbConn2, 1, 3, 1<BR><BR><BR>rsCheck.RecordCount<BR><BR>ADODB.Reco rdset (0x800A0E78)<BR>Operation is not allowed when the object is closed.<BR>/nextech/inet/services/accelerator/accck.asp, line 94<BR>

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

    Default What does your sp do?

    does it return any rows?<BR><BR>if there are no selects use the execute method of the connection object and check the rowseffected property.<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