ANYONE?? Limit ASP search result to 10 per page

[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;

 

[[MVP] S. Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Dan Artuso]

Hi,
If I understand you correctly, what you want to implement
is recordset paging.
I have no idea if FrontPage will do that for you.
I suspect you have to hand code it.

Here is a link that shows exactly what you need to do.
http://www.asp101.com/articles/recordsetpaging/index.asp