Microsoft KB Archive/831093

= How to use a URL parameter to filter a Data View Web part in FrontPage 2003 =

Article ID: 831093

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Office FrontPage 2003
 * Microsoft Windows SharePoint Services

-





SUMMARY
This article discusses how to pass connection information for filtering data through a URL reference in Microsoft Office FrontPage 2003.



MORE INFORMATION
You can use Data View Web parts with existing URL hyperlinks that pass information for processing. To do this, first update your existing Web page to use a Data View Web part, and then modify the parameter binding location to use the URL parameter string that you want to capture.

Insert a Data View
To add a Data View to your Web, page follow these steps:
 * 1) Click the position on the page where you want your Data view to reside.
 * 2) On the Data menu, click Insert Data View.
 * 3) Click the data source that you want to use for your view.
 * 4) Click Insert Data View.

Modify the parameter binding location
To modify the Data View to accept data from a URL, follow these steps:  Open the page in FrontPage 2003. At the bottom of the edit window, click Code. On the Edit menu, click Find. In the Find What box, type ParameterBinding Name=&quot;filterParam&quot;, and then click Find Next. Find the Location attribute in this line. Replace the current Location attribute value with the following: &quot;Postback;Connection;QueryString&quot; Where  is the parameter in the URL query string that you want to pass to the Data View filter. At the bottom of the edit window, click Design.</li> Add a filter to the Data View. To do so, follow these steps <ol style="list-style-type: lower-alpha;"> On the Data menu, click Filter.</li> Click Click here to add a new clause.</li> Select the Field Name that you want to filter on.</li> For the Value to compare against, click [Input Parameter].</li></ol> </li> Save the Web page.</li></ol>

To view the results of the filter, add the following parameter to your URL string that references this page: =&quot; &quot; where   is the item that you want to compare to.

Additional query words: FP11 FP2003 SQL Query

Keywords: kbhowto kbprogramming kbwebpublishing KB831093

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.