Results 1 to 2 of 2

Thread: recordcount

  1. #1
    Join Date
    Dec 1969

    Default recordcount

    hallo. why am i still getting -1 for recordcount from the following code? is there something specfic to do with cursortypes i&#039m still not understanding?<BR><BR>dim orecordset<BR>set orecordset = Server.CreateObject("ADODB.RecordSet")<BR>orecords et.ActiveConnection = "DRIVER=Microsoft Access Driver (*.mdb); DBQ=" & Server.MapPath("elog.mdb")<BR>orecordset.cursortyp e = adopenstatic<BR><BR> "select reportid from report"<BR>reportnumber = orecordset.recordcount<BR>orecordset.close

  2. #2
    Join Date
    Dec 1969

    Default RE: recordcount

    Try movelast method on the Recordset and then take the recordcount and after that you can say movefirst .

Posting Permissions

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