Display x number of records

[Dave Karmens]

How could I display *only* x# of records even if the select statement
returns a value >x?

[Raymond D'Anjou \(raydan\)]

Select top 10

or

SET ROWCOUNT @x
select ... from tableName ...

"Dave Karmens" <spam_just1coder@yahoo.ca> wrote in message
news:OiD%23a7lIEHA.3200@TK2MSFTNGP10.phx.gbl...

> How could I display *only* x# of records even if the select statement
> returns a value >x?

[Bob Barrows [MVP]]

Dave Karmens wrote:

> How could I display *only* x# of records even if the select statement
> returns a value >x?

Several options, starting with the best:
1. Modify the query to only return the number of records you wish to display
2. When using GetRows to stuff your recordset's data into an array, supply
the argument to tell the function to only put x records into the array.
3. Count the records as you write them to the Response object, stopping when
you've reached the xth record

For more information, search for recordset paging at aspfaq.com

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray at]

Why not just select x# of them?

select top 40 ......

And if for some reason you still want to return them all, then the answer
depends on how you're currently displaying them. Are you just looping
through your RS? If so, you could do:

Dim i
i = 0
do while not rs.eof

''your code that displays record
i=i+1
If i = 40 then exit do
rs.MoveNext
Loop

Ray at work

"Dave Karmens" <spam_just1coder@yahoo.ca> wrote in message
news:OiD%23a7lIEHA.3200@TK2MSFTNGP10.phx.gbl...

> How could I display *only* x# of records even if the select statement
> returns a value >x?

[Dave Karmens]

that's it:

> i=i+1
> If i = 40 then exit do

Thanks Ray.

Ray at <%=sLocation%> [MVP] wrote:

> Why not just select x# of them?
>
> select top 40 ......
>
> And if for some reason you still want to return them all, then the answer
> depends on how you're currently displaying them. Are you just looping
> through your RS? If so, you could do:
>
> Dim i
> i = 0
> do while not rs.eof
>
> ''your code that displays record
> i=i+1
> If i = 40 then exit do
> rs.MoveNext
> Loop
>
> Ray at work
>
> "Dave Karmens" <spam_just1coder@yahoo.ca> wrote in message
> news:OiD%23a7lIEHA.3200@TK2MSFTNGP10.phx.gbl...
>

>>How could I display *only* x# of records even if the select statement
>>returns a value >x?

>
>
>

[Bullschmidt]

What's after TOP? by graz - 8/31/2000
[url]http://www.sqlteam.com/item.asp?ItemID=566[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!