ANYONE?? Limit ASP search result to 10 per page

  • Thread starter Thread starter Wendy P.
  • Start date Start date
W

Wendy P.

HI,

I am trying to limit the asp results on each page to 10.

Please note that I am using FRONTPAGE 98 and ACCESS 2002,
SQL statements.

Here's my exisiting code...what do I do now? Thanks so much!

SELECT Products.Category, Products.ProductType,
Products.ProductName, Left([Products.Description],225) AS
shortdesc
FROM Products
WHERE Products.Category LIKE '%Specials%'
ORDER BY Products.ProductType DESC , Products.ProductName;
 
In the output to the ASP page, put a variable that counts the rows.
When you get to 10 rows, add an extra <br>, and reset the variable to 1.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top