SQL question "SELECT TOP 15"

Hi

When I am using a ASP SQL question to my Access 2000 db via IIS 5.0 and have
the SELECT TOP 15 syntax in the SQL question I get 15 rows in my answer if a
have many rows in the table, but if I don´t have many rows I get MORE ( >
15) rows in my answer?

Why?

Thanks!!!!!!

Best Regards

Staffan

re: SQL question "SELECT TOP 15"

Gerlow wrote on 14 mrt 2004 in microsoft.public.inetserver.asp.general:
[color=blue]
> When I am using a ASP SQL question to my Access 2000 db via IIS 5.0
> and have the SELECT TOP 15 syntax in the SQL question I get 15 rows in
> my answer if a have many rows in the table, but if I donït have many
> rows I get MORE ( > 15) rows in my answer?
>[/color]

Please define many.

If you have 3 rows, you get 17 ? ;=)

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

re: SQL question "SELECT TOP 15"

You're going to have to show your code and an example of the problem. We
can't solve narrative.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Gerlow" <gerlow@hej.com> wrote in message
news:up3uvadCEHA.2308@tk2msftngp13.phx.gbl...[color=blue]
> Hi
>
> When I am using a ASP SQL question to my Access 2000 db via IIS 5.0 and[/color]
have[color=blue]
> the SELECT TOP 15 syntax in the SQL question I get 15 rows in my answer if[/color]
a[color=blue]
> have many rows in the table, but if I don´t have many rows I get MORE ( >
> 15) rows in my answer?
>
> Why?
>
> Thanks!!!!!!
>
> Best Regards
>
> Staffan
>
>[/color]

re: SQL question "SELECT TOP 15"

On Sun, 14 Mar 2004 16:16:39 +0100, "Gerlow" <gerlow@hej.com> wrote:
[color=blue]
>When I am using a ASP SQL question to my Access 2000 db via IIS 5.0 and have
>the SELECT TOP 15 syntax in the SQL question I get 15 rows in my answer if a
>have many rows in the table, but if I don´t have many rows I get MORE ( >
>15) rows in my answer?
>
>Why?[/color]

Can't tell. Show some code and a database structure. Sample data
would help as well. Keep in mind a WHERE clause could modify what
your TOP 15 actually are.

Jeff