Re: Help with DataView and QueryString

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try this
How to use a URL parameter to filter a Data View Web part in FrontPage
2003
(831093) - Explains how to use Data View Web parts with existing URL
hyperlinks that pass information for processing. To do this, you must first
update your existing Web page to use a Data View Web part, and then modify
the parameter binding location.
http://support.microsoft.com/default.aspx?scid=kb;en-us;831093


Regards,
Ian
http://www.wssdemo.com

<gowens@xxxxxxxxxxxxxxxx> wrote in message
news:1118165979.077115.174900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have the following scenario:
>
> On web part page #1 I have a dataview web part which brings back some
> data from a SQL server dB. I've included a hyperlink on one of the
> fields. The raw hyperlink looks like the follwing:
>
> /Pages/OfficeDirectory.aspx?OfficeCode='{@OFFICE_CODE}'
>
> The intent here is that the hyperlink will pass the value of the
> associated row through the querystring.
>
> On the OfficeDirectory.aspx page I have another dataview web part which
> calls a stored procedure which takes parameter (you guessed it:
> @OfficeCode).
>
> It appears that the hyperlink on page #1 is working correctly. However,
> I can't get the OfficeDirectory.aspx page (DVWP) to accept/use the
> querystring parameter.
>
> If I modify the data source for the DVWP to supply the
> QueryString(OfficeCode) then the data source retrieves no data - and I
> can't add the DVWP to the page. If I hard code a value for the data
> source parameter - data is retrieved but it's not dynamic.
>
> Since I'm sooo new to WSS/SPS I'm not even sure that this is the
> correct approach.
>
> I sure would appreciate some guru help and input on this!!!
>
> Glenn
>


.

Relevant Pages