Re: Using Query Strings in FP2003 & Sharepoint

From: Jim Clouse (jwclouse_at_127.0.0.1)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 09:34:20 -0600

Thanks John for the quick and thorough answer. I really appreciate it.

I had thought about connecting Web Parts and now that you have recommended
it, that is exactly how I will proceed.

Jim

"John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message
news:eZ3bVRBGEHA.692@TK2MSFTNGP09.phx.gbl...
> Hi Jim,
>
> Using Filter will actually be faster than Query Strings, because for SQL
> data the filter is preformed at the Data Source level, where as, with
Query
> Strings, the filter is written into the XSL transform, so all the records
> will be returned first, and then they will be filtered.
>
> For arbitrary XML sources, the filter and the QueryString will be
equivelent
> performance because both happen at the data view level, but for SQL and
WSS
> List data, using Filter will be faster.
>
> That said, if you want to use QueryStrings, here is an article I wrote:
>
> http://support.microsoft.com/?id=831093
>
> You could also use Web Part Connections, where you would have a Data View
of
> just the City names and pass that connection information (Data..Web Part
> Connections) to the page with your full data view on it. Again, this
filter
> will happen at the data source level, so it should be relatively fast.
> --
> Thanks!
> John Jansen
> Microsoft Office FrontPage
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Jim Clouse" <jwclouse@127.0.0.1> wrote in message
> news:O4GJeWAGEHA.3764@TK2MSFTNGP12.phx.gbl...
> > I never got an answer to this posting after about two weeks so I am
trying
> > again. Hope everyone understands.
> >
> >
> > We are using FP2003 along with Sharepoint Services to build XML
> data-driven
> > websites. We use a SQL database that contains fields like countryname,
> > statename, cityname, etc.
> >
> > I want to use query strings to perform tasks such as getting all the
> hotels
> > in Nashville, TN. How do I use query strings in FP2003 with Sharepoint
to
> > render the results that I want. (I do not want to use the filter option
> to
> > do this since it will take a lot longer to query a 56,000 record
database
> > when all I want is to access 125 records that meet this criteria.)
> >
> > Documentation on using query strings with Sharepoint and FP2003 is
> severely
> > lacking.
> >
> > Thanks!
> >
> > JWC
> >
> >
>
>