Recordset Paging - Show 10 results per pg

[Wendy P.]

Someone out there has got to know how to do this! I have
been banging my head into a wall for a week now - please
help! :-/

I am a real Microsoft JUNKIE because I'm using FrontPage 98
(SQL Statements) to query an Access database.

**How can I get the results.asp page to only show 10
records at a time? Of course, I will need the Previous and
Next links too.**

Here's my coding...

SELECT Products.ImageSmall, Products.Category,
Products.ProductType, Products.ProductName, Products.Stock,
Products.AgeGroup, Products.SystemRequirements,
Products.RetailPrice, Products.Manufacturer, Products.Link,
Left([Products.Description],225) AS shortdesc
FROM Products
WHERE Products.Category LIKE '%H%'
ORDER BY Products.ProductType DESC , Products.ProductName;

Here's the website page that I'm working on...

http://www.ChildrensSoftwareOnline.com/new/homeschool.asp


THANK YOU!!!!

 

[j]

I haven't done this kind of stuff in a while but can't you run a query then
loop through the recordset? Keep a count and resubmit it to the form so you
know where you left off. If you don't get anywhere let me know I'll see
if I can come up with an example.

(e-mail address removed)