Results 1 to 4 of 4

Thread: counter

  1. #1
    Tyler Parrott Guest

    Default counter

    Is there anyway (using ASP&#039s and VBScript) To display the number of records returned by a Query at the top of the page?

  2. #2
    Susanne Guest

    Default RE: counter

    I Use<BR>Response.Write(rs.RecordCount & " Records Displayed")<BR><BR>Hope this helps<BR>Cheers<BR>Susanne<BR>

  3. #3
    Tyler Parrott Guest

    Default -1

    I used that code but I got negative one for every query. Where should this code be placed?<BR>Tyler

  4. #4
    Join Date
    Dec 1969

    Default RE: -1

    This is because .RecordCount is only supported by certain recordset cursors. Chances are you&#039re using the default cursor type, which is a forward-only cursor, which means you can&#039t move forwards/backwards, which is required of the .RecordCount method.<BR><BR>Here is an article that explains it all:<BR>Recordset Cursors: Choosing the Right Cursor for the Job<BR><BR><BR>Happy Programming!

Posting Permissions

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