Limit Rows Returned ASP and MySQL

Giganews Newsgroups
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