Skip to main content
Participant
March 30, 2012
Question

Dataobjects RecordSet Navigation loses Parameter Value

  • March 30, 2012
  • 2 replies
  • 553 views

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?

This topic has been closed for replies.

2 replies

bazzer747Author
Participant
March 30, 2012

I'm using CS5.5 on an ASPX page.

Would love it if I could see a 'maintain querystring value'!

Participating Frequently
March 30, 2012

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.