Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
What version of DW are you using? Is there not an option in the navigation behavior to maintain querystring values? We need to see the complete code to really tell what's happening, but I'm no ASP.NET expert.
Copy link to clipboard
Copied
I'm using CS5.5 on an ASPX page.
Would love it if I could see a 'maintain querystring value'!