Need help counting records...

Results 1 to 2 of 2

Thread: Need help counting records...

  1. #1
    Join Date
    Dec 1969

    Default Need help counting records...

    I have the following code:<BR><BR>Set NumberACCOUNT = Server.CreateObject("ADODB.Recordset")<BR>NumberAC COUNT.Open "Select * from r6l_1on1_ACCOUNT" , conntemp, 3, 3<BR>NumberOfAccounts = ( NumberACCOUNT.RecordCount + 1 )<BR><BR>NumberACCOUNT.RecordCount just returns 0, even though there ARE entries in that table...Ive also tried in the SQL, SELECT COUNT(*) AS NumberOfAccounts...that didnt work either...anyone have any ideas? Thanks...<BR><BR>Robert Bryant<BR><BR>PS: Thank you, Scott for putting in that reg feature!

  2. #2
    Join Date
    Dec 1969

    Default RE: Need help counting records...

    More info:

Posting Permissions

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