SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot Bruce Lee's Avatar
    Join Date
    Jan 2005
    Location
    Singapore
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    getting recordcount as -1

    SET objRds = Server.CreateObject("ADODB.Recordset")
    objRds.CursorType = 1
    objRds.LockType = 3 'adLockOptimistic
    objRds.ActiveConnection = objConn
    objRds.open strSql
    objRds.Recordcount

    when i run the srl in query anaylzer, i get records, more than 1
    but record count gives me -1

    yyyyyyyyyy???????
    Happy Coding!!!
    Bruce Lee.

  2. #2
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    which query ?

    this post should be at the db forum

  3. #3
    SitePoint Member
    Join Date
    Jun 2005
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try to check out the link might help..

    http://www.adopenstatic.com/faq/recordcounterror.asp

    HTH...

    Happy programming...


Bookmarks

Posting Permissions

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