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 ASPFAQs, category Databases, Errors

    The link to the ASPFAQs is at the top right corner of this page.<BR><BR>(Over 5,400 other people have asked this question.)<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