How can i only display 4 rows from a returned recordset? 1

[F430]

Hello,

How can i only display 4 rows from a returned recordset?

Im using ASP and MS SQL Server.

Would it be easier to create a query in the DB or just do it in ASP, i would rather have it in ASP tho!

Thanks

 

[DotNetGnat]

it is very easy to do at the sql level...just use...

SELECT TOP 4 * from mytable...

-DNG

 

[F430]

Is that in the ASP SQL statement or in the DB query

 

[DotNetGnat]

ASP SQL Statement...

-DNG

 

[damber]

What's the matter with your previous thread on exactly the same question ?????

thread333-1161328



A smile is worth a thousand kind words. So smile, it's easy!

 

[onpnt]

ASP SQL Statement

that's a interesting new technology I haven't heard of yet ;-)

 

[DotNetGnat]

i thought the original poster was referring to the SQL query on the ASP page...so didnt wanted to confuse him and swayed with his jargon

-DNG