Record Count Property

Results 1 to 9 of 9

Thread: Record Count Property

  1. #1
    Al Bear Guest

    Default Record Count Property

    I have arecord set. but when running a record count I get the value -1 which means the number of records can't be determined. any idea how to resolve this problem

  2. #2
    Eddie Campbell Guest

    Default RE: Record Count Property

    Make sure that you use the correct coursor location E.g.<BR><BR>MyRs.Open MySql, ObjConn, 3, 3

  3. #3
    What is the cursor type.. Guest

    Default RE: Record Count Property

    What is the cursor type you are using to create the recordset.

  4. #4
    Al Bear Guest

    Default cursor type ????

    not sure what should it be???

  5. #5
    Vijay Guest

    Default RE: cursor type ????

    Paste the line of the code(set rs=...) in the forum.<BR><BR>

  6. #6
    Al Bear Guest

    Default code..

    Set objrec = server.createobject ("ADODB.recordset")

  7. #7
    Vijay Guest

    Default RE: code..

    No,No..<BR><BR>What is the next line.<BR><BR>is it sql,con,3,3

  8. #8
    Al Bear Guest

    Default sorry ...more code SQL, DBcon<BR><BR>What dose the 3,3, do????

  9. #9
    Vijay Guest

    Default RE: sorry ...more code

    your code will open the recordset in forward only cursor, where the recordcount will not work.(i hope i am right, i am out of asp since last 8 months)<BR><BR>just put 3,3 & see the magic.

Posting Permissions

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