SQL question "SELECT TOP 15"

[Gerlow]

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

[Evertjan.]

Gerlow wrote on 14 mrt 2004 in microsoft.public.inetserver.asp.general:

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?

Please define many.

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

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

[Aaron Bertrand [MVP]]

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" <ge****@hej.com> wrote in message
news:up**************@tk2msftngp13.phx.gbl...

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

[Jeff Cochran]

On Sun, 14 Mar 2004 16:16:39 +0100, "Gerlow" <ge****@hej.com> wrote:

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?

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