Limit Rows Returned ASP and MySQL

Subject:	Limit Rows Returned ASP and MySQL
Posted by:	T.J (no1@home.invalid)
Date:	Wed, 6 Feb 2008

I am trying to set a limit of rows displayed
using ASP and MySQL database.

I keep reading that LIMIT should work

I have tried

SELECT * FROM tblCompany LIMIT 2 WHERE strCountry LIKE '%"

but just get an error.
How can I just set an amount of results to display?

TIA.

Replies

Re: Limit Rows Returned ASP and MySQL posted by John Bokma on 6 Feb 2008
Re: Limit Rows Returned ASP and MySQL posted by Jerry Stuckle on Wed, 06 Feb 2008