getting the rs count

Results 1 to 4 of 4

Thread: getting the rs count

  1. #1
    John F Guest

    Default getting the rs count

    How can I get the recorsdset count as the code loops through the database to find records that meet a certain criteria passed from a form?

  2. #2
    TT Boy Guest

    Default RE: getting the rs count

    get all the rocords then use the count() function in your sql statement or use objRS.Recordcount<BR><BR>But make sure you create your recordset the correct way.....see the VSB scripting reference from micosoft for more info

  3. #3
    John F Guest

    Default Can't find

    an example of the syntax for this. Can you help?

  4. #4
    Join Date
    Dec 1969

    Default SQL Count()

    One way....<BR><BR>SELECT COUNT(*) FROM myTable WHERE ............<BR><BR><BR>Also, please take a look at which answers some common questions

Posting Permissions

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