Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Dataobjects RecordSet Navigation loses Parameter Value

Explorer ,
Mar 30, 2012 Mar 30, 2012

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?

TOPICS
Server side applications

Views

508
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 30, 2012 Mar 30, 2012

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.

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Mar 30, 2012 Mar 30, 2012

Copy link to clipboard

Copied

LATEST

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

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

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines