Thank you all for your help! My pages are up and running

Here is the code from the ASP page

Set objNav = Server.CreateObject("ADODB.Command")

ObjNav.ActiveConnection = cn

objNav.CommandText = "sp_navigation"

objNav.CommandType = 4

SET objParam2 = objNav.CreateParameter("@myNumPost",131, 1, 4)

objNav.Parameters.Append objParam2

objNav.Parameters("@myNumPost") =...

I can't set top count using a parameter.MS SQL does not allow it apparently. And the rowcount is set before I begin my select statement so I can't seem...

Thanks so much! Silly oversite.