Professional Web Applications Themes

RecordCount Property and SQL - ASP Database

When using an access database, I could retrieve the recordcount with code below For r = 1 to RS.RecordCount When I try the same syntax on a SQL database, the RecordCount always returns -1 Is there another quick way to get the Record Count with SQL so I could run a similiar statement?...

  1. #1

    Default RecordCount Property and SQL

    When using an access database, I could retrieve the recordcount with code
    below

    For r = 1 to RS.RecordCount

    When I try the same syntax on a SQL database, the RecordCount always
    returns -1


    Is there another quick way to get the Record Count with SQL so I could run a
    similiar statement?


    Scott Guest

  2. #2

    Default Re: RecordCount Property and SQL

    [url]http://www.aspfaq.com/2193[/url]

    --
    Aaron Bertrand, SQL Server MVP
    [url]http://www.aspfaq.com/[/url]

    Please reply in the newsgroups, but if you absolutely
    must reply via e-mail, please take out the TRASH.


    "Scott" <salexbaileymsn.com> wrote in message
    news:eRxx3v9TDHA.2092TK2MSFTNGP10.phx.gbl...
    > When using an access database, I could retrieve the recordcount with code
    > below
    >
    > For r = 1 to RS.RecordCount
    >
    > When I try the same syntax on a SQL database, the RecordCount always
    > returns -1
    >
    >
    > Is there another quick way to get the Record Count with SQL so I could run
    a
    > similiar statement?
    >
    >

    Aaron Bertrand [MVP] Guest

  3. #3

    Default Re: RecordCount Property and SQL

    Scott wrote:
    > When using an access database, I could retrieve the recordcount with
    > code below
    >
    > For r = 1 to RS.RecordCount
    >
    > When I try the same syntax on a SQL database, the RecordCount always
    > returns -1
    >
    >
    > Is there another quick way to get the Record Count with SQL so I
    > could run a similiar statement?
    In addition to Aaron's article, you should be aware that using a client-side
    cursor will be more expensive in terms of resources and performance than the
    default server-side forward-only cursor. You should consider using GetRows
    to stuff your data into an array so you can forego the recordset loop and do
    a much faster array loop instead. This has the added benefit of allowing you
    to immediately close your recordset and connection, allowing the connection
    to be used by another user which can also boost your overall performance and
    scalability.

    Bob Barrows


    Bob Barrows Guest

Similar Threads

  1. Replies: 0
    Last Post: November 13th, 11:04 AM
  2. recordCount property
    By fu-meng in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: May 16th, 03:48 PM
  3. Getting a recordcount
    By Andy Levy in forum PHP Development
    Replies: 3
    Last Post: October 29th, 08:55 AM
  4. recordcount -1
    By middletree in forum ASP
    Replies: 8
    Last Post: October 16th, 02:06 PM
  5. Why does the RecordCount property always = -1
    By George Mizzell in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 13th, 01:27 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139