RecordCount problem with static recordset

• Alan Murray

  SSC Veteran

  Points: 249

  More actions

  July 23, 2004 at 10:02 am

  #83445

  I want to use RecordCount before i run through the recordset. I'm specifying the cursor type and there are three records returned, however RecordCount is always -1! Any ideas?

  conn = Server.CreateObject("ADODB.Connection")

  conn.Open(Application("JobDB"));

  cmd = Server.CreateObject("ADODB.Command")

  cmd.ActiveConnection = conn;

  cmd.CommandType = adCmdStoredProc;

  cmd.CommandText = "GetDataRequest";

  cmd.Parameters.Append (cmd.CreateParameter("userID", adVarChar, adParamInput, 64));

  cmd.Parameters("userID") = Application("userID");

  rs = Server.CreateObject("ADODB.Recordset");

  rs.CursorType = 3;

  rs.Open(cmd);

• Robbac

  Ten Centuries

  Points: 1090

  More actions

  July 23, 2004 at 10:14 am

  #515934

  Hi!

  There is a problem to use .RecordCount if the recordset does not contain all columns of a table, and don't ask me why it is like that

  To solve this you could run thru all records with .MoveNext and store the number of records in a temporary variable and then use .MoveFirst to get back to the first record of the recordset.

  
  robbac
  ___the truth is out there___

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  July 23, 2004 at 12:47 pm

  #515945

  Try changing the ADODB cursorlocation to be adUseClient.  Then you should be able to get a recordcount.  The problem is the recordcount uses client always and when the cursor location is on the server it can't get a count.

  If the above gives a -1 add re.movelast and rs.movefirst and then check record count.

   

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• Philippe Proulx

  Newbie

  Points: 5

  More actions

  July 23, 2004 at 1:40 pm

  #515960

  Simply do a .movelast , .movefirst and then do the .recordcount worked for me. for extra security you can also put a order by in your query (even if you dont need it). Dont ask me why either ..... it just works.

  PhilTheThrill

  ---

  Never argue with a fool.
  First ill bring you down to his level, then, ill beat you with experience.
  Phil.

• Julian Kuiters

  SSCertifiable

  Points: 6585

  More actions

  July 25, 2004 at 10:10 pm

  #516019

  To get a RecordCount, you must use a Client side cursor location (adUseClient), and a static cursor type (adOpenStatic). ADO then gets all the records back from the server so you can check RecordCount

  connection.CursorLocation=adUseClient

  connection.CursorType = adOpenStatic

   

  ---

  Julian Kuiters
  juliankuiters.id.au