Results 1 to 2 of 2

Thread: Recordcount

  1. #1
    Join Date
    Dec 1969

    Default Recordcount

    I have an Access 2000 db that I have built queries in. I am using the ADO command object to build my parameters like so: <BR><BR>Set objCommand = Server.CreateObject("ADODB.Command") <BR>objCommand.ActiveConnection = conntemp <BR>objCommand.CommandText = "QCATEGORYBYDESC" <BR>objCommand.CommandType = adCmdStoredProc <BR><BR>set objParameter = objCommand.CreateParameter("Description",adChar,ad ParamInput, 255, strDescription) <BR>objCommand.Parameters.Append objParameter <BR><BR>Set RecordSet = objCommand.Execute <BR><BR>RecordSet.recordcount returns a -1 but guess what..... <BR><BR>it will loop through the recordset with this logic: <BR><BR>Do While NOT RecordSet.EOF <BR>... <BR>Loop <BR><BR>What is the deal???? <BR>Thanks for your help.

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordcount

    Check out the faq&#039;s (link at top right of page) do a search on database queries, and general, there is an faq about this

Posting Permissions

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