Counting entries in DB

Results 1 to 2 of 2

Thread: Counting entries in DB

  1. #1
    GeorgeW Guest

    Default Counting entries in DB

    How would I count how many entries there are with a particular id in a database?

  2. #2
    Join Date
    Dec 1969

    Default How counting....

    Well,<BR><BR>Select * from lateeda where id = &#039"& id &"&#039"<BR><BR>and use the recordset.count<BR><BR>or you could stick the rs in an array and check its upper bound<BR><BR>or in Sql Server you can select count(*) as cnt from waahoo where id = "&id&"<BR><BR>lots of options,<BR>you could move through the recordset and have a counter loop,<BR>you could do the same in an array, loop through it and add 1 to the counter.<BR><BR>just use select count, if you can.<BR><BR>skol`

Posting Permissions

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