Dataobjects RecordSet Navigation loses Parameter Value
Hi,
From a page I pass some parameters to include in a SQL statement in the linked page:
Page 1:
"professional-shop.aspx?fType=Clothing&fGroup=Mens"
Page 2:
SELECT *
FROM tbInventory
WHERE (tbInventory.fGroup LIKE ?) AND (tbInventory.fType LIKE ?)
This works fine.
However, Page 2 often has 30 or 40 items and so I wanted to use the RecordSet Navigation to limit to records shown on a page to 10. When I do this the first time I click on the navigation (say the Next Record), the filter used by the parameters is lost and all records in the table are displayed. Page 2 has lost the values for these 2 parameters.
How can I ensire the value of these 2 parameters is kept when using the navigation links?
