Results 1 to 2 of 2

Thread: RecordCount

  1. #1
    Rob Guest

    Default RecordCount

    I am not using dynamic SQL but a Stored Procedure. In a SP does the cursor type default to adOpenForwardOnly and if it does can it be changed in the Command so I can use RecordCount. Something like this:<BR><BR>set adoConn = Server.CreateObject("ADODB.Connection")<BR>adoConn .ConnectionTimeout = 300<BR>adoConn.CommandTimeout = 300<BR>set adoCmd = Server.CreateObject("ADODB.Command")<BR>adoCmd.Com mandTimeout = 300<BR><BR>adoCmd.CursorType = adOpenDynamic<BR><BR>set adoRS = Server.CreateObject("ADODB.Recordset")<BR>adoConn. Open Application("DataConn")<BR>adoCmd.CursorType = adOpenDynamic<BR><BR>adoCmd.CommandText = "PB_FindClaims"<BR>adoCmd.CommandType = adCmdStoredProc<BR>Set adoCmd.ActiveConnection = adoConn<BR>Set adoParam1 = adoCmd.CreateParameter("@P1_SSN", adInteger, adParamInput)<BR>adoCmd.Parameters.Append adoParam1<BR>Set adoParam2 = adoCmd.CreateParameter("@P2_DepNumber", adInteger, adParamInput)<BR>adoCmd.Parameters.Append adoParam2<BR>adoCmd("@P1_SSN") = m_iSSN<BR>adoCmd("@P2_DepNumber") = m_iDepNum<BR><BR>Thank you for any help or input you could give.

  2. #2
    Rob Guest

    Default RE: RecordCount

    As far as I know, it always defaults to adopenforward.<BR>Take a look at this link and pay special attention to link 2<BR><BR><BR>Rob

Posting Permissions

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