ATTN: John Jansen

[John]

COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing something wrong. It says,
"There are no items to show in this view of the "test" list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column
4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"
8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target Action "Get Sort/Filder
From"
Columns in Form Web Part "T1" Columns in test "Last_Name"
Finished
11. Saved the page

What did I do wrong?


John

Sorry I'm jumping in here late. I believe the steps below will get you what
you want using Connections from within FrontPage 2003...

Convert the view you want to be filtered into a Data View Web Part using
FrontPage
Create a filter where your Field Name CONTAINS [Input Parameter]

Insert a Form Web Part onto the page
Use Web Part connections to pass the Form value as a parameter to the Data
View

Save the page.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no

rights.

 

[John Jansen \(MSFT\)]

So close...

See inline.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing something wrong. It says,
"There are no items to show in this view of the "test" list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column

Here you have inserted a List View Web Part, but what you want is a Data
View Web Part (they are similar, but just different enough). So Right click
the view and choose "Convert to XSLT Data View" (there are other ways to get
a data view, but this is the easiest).

4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"

When you have a data view, the Value drop-down will be populated with
available Parameters. From the Value drop-down menu choose "[Input
Parameter]"

8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target Action "Get Sort/Filder
From"

Your target action should be "Modify view using Parameters From..."

Columns in Form Web Part "T1" Columns in test

"Last_Name"

Columns in Form: T1, but columns in test will be [Input Parameter]

Finished
11. Saved the page

And now you need to preview in the Browser (hit F12) and type some value
into the Form field and hit Submit.

That should do it.

What did I do wrong?


John

Sorry I'm jumping in here late. I believe the steps below will get you what
you want using Connections from within FrontPage 2003...

Convert the view you want to be filtered into a Data View Web Part using
FrontPage
Create a filter where your Field Name CONTAINS [Input Parameter]

Insert a Form Web Part onto the page
Use Web Part connections to pass the Form value as a parameter to the Data
View

Save the page.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no

rights.

 

[John]

John,

It works perfectly!!

Where can I read more about the differences between the List View and Data
View Web Parts?

Thanks!!
John

So close...

See inline.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing something wrong. It says,
"There are no items to show in this view of the "test" list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column

Here you have inserted a List View Web Part, but what you want is a Data
View Web Part (they are similar, but just different enough). So Right click
the view and choose "Convert to XSLT Data View" (there are other ways to get
a data view, but this is the easiest).

4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"

When you have a data view, the Value drop-down will be populated with
available Parameters. From the Value drop-down menu choose "[Input
Parameter]"

8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target Action "Get Sort/Filder
From"

Your target action should be "Modify view using Parameters From..."

Columns in Form Web Part "T1" Columns in test

"Last_Name"

Columns in Form: T1, but columns in test will be [Input Parameter]

Finished
11. Saved the page

And now you need to preview in the Browser (hit F12) and type some value
into the Form field and hit Submit.

That should do it.

What did I do wrong?


John

Sorry I'm jumping in here late. I believe the steps below will get

you
what

you want using Connections from within FrontPage 2003...

Convert the view you want to be filtered into a Data View Web Part using
FrontPage
Create a filter where your Field Name CONTAINS [Input Parameter]

Insert a Form Web Part onto the page
Use Web Part connections to pass the Form value as a parameter to the Data
View

Save the page.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no

rights.

 

[Jim Buyens]

I don't believe you need to do steps 5-7. In fact, I think
these are filtering on the literal "[T1]".

Step 10 should set up all the filtering you need.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing something wrong. It says,
"There are no items to show in this view of the "test" list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column
4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"
8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target Action "Get Sort/Filder
From"
Columns in Form Web Part "T1" Columns in test "Last_Name"
Finished
11. Saved the page

What did I do wrong?


John

Sorry I'm jumping in here late. I believe the steps

below will get you
what

you want using Connections from within FrontPage 2003...

Convert the view you want to be filtered into a Data View Web Part using
FrontPage
Create a filter where your Field Name CONTAINS [Input Parameter]

Insert a Form Web Part onto the page
Use Web Part connections to pass the Form value as a parameter to the Data
View

Save the page.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties,

and confers no
rights.


.

 

[John Jansen \(MSFT\)]

Hi Jim, you are right about the fact that his steps would have him filtering
on the string [T1], that's why I made sure to specify choosing [Input
Paramter] from the drop-down. Since List View web parts don't provide this
parameter from the drop-down, he must have been confused and just typed in
his own value.

However, you do still need to perform steps 5 - 7 or else the view you
connect to would take in the parameter but have no idea what to do with it.

The thing that causes confusion here is that in order to do the "Contains"
side of things, you cannot just set up connections that perform the
filtering for you, you need to set up the filter first and pass it a
parameter which populates the Contains clause via connections.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

I don't believe you need to do steps 5-7. In fact, I think
these are filtering on the literal "[T1]".

Step 10 should set up all the filtering you need.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing something wrong. It says,
"There are no items to show in this view of the "test" list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column
4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"
8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target Action "Get Sort/Filder
From"
Columns in Form Web Part "T1" Columns in test "Last_Name"
Finished
11. Saved the page

What did I do wrong?


John

Sorry I'm jumping in here late. I believe the steps

below will get you
what

you want using Connections from within FrontPage 2003...

Convert the view you want to be filtered into a Data View Web Part using
FrontPage
Create a filter where your Field Name CONTAINS [Input Parameter]

Insert a Form Web Part onto the page
Use Web Part connections to pass the Form value as a parameter to the Data
View

Save the page.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties,

and confers no
rights.


.

 

[John]

John,

Can I pass more than one parameter?

John

Hi Jim, you are right about the fact that his steps would have him filtering
on the string [T1], that's why I made sure to specify choosing [Input
Paramter] from the drop-down. Since List View web parts don't provide this
parameter from the drop-down, he must have been confused and just typed in
his own value.

However, you do still need to perform steps 5 - 7 or else the view you
connect to would take in the parameter but have no idea what to do with it.

The thing that causes confusion here is that in order to do the "Contains"
side of things, you cannot just set up connections that perform the
filtering for you, you need to set up the filter first and pass it a
parameter which populates the Contains clause via connections.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

I don't believe you need to do steps 5-7. In fact, I think
these are filtering on the literal "[T1]".

Step 10 should set up all the filtering you need.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing something wrong. It says,
"There are no items to show in this view of the "test" list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column
4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"
8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target Action "Get Sort/Filder
From"
Columns in Form Web Part "T1" Columns in test "Last_Name"
Finished
11. Saved the page

What did I do wrong?


John


Sorry I'm jumping in here late. I believe the steps below will get you
what
you want using Connections from within FrontPage 2003...

Convert the view you want to be filtered into a Data View Web Part using
FrontPage
Create a filter where your Field Name CONTAINS [Input Parameter]

Insert a Form Web Part onto the page
Use Web Part connections to pass the Form value as a parameter to the Data
View

Save the page.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no
rights.


.

 

[John Jansen \(MSFT\)]

Yeah, you just need to create new ones in the XSLT (copy and paste the
filterParam we create by default and give it a new name).

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

John,

Can I pass more than one parameter?

John

Hi Jim, you are right about the fact that his steps would have him filtering
on the string [T1], that's why I made sure to specify choosing [Input
Paramter] from the drop-down. Since List View web parts don't provide this
parameter from the drop-down, he must have been confused and just typed in
his own value.

However, you do still need to perform steps 5 - 7 or else the view you
connect to would take in the parameter but have no idea what to do with it.

The thing that causes confusion here is that in order to do the "Contains"
side of things, you cannot just set up connections that perform the
filtering for you, you need to set up the filter first and pass it a
parameter which populates the Contains clause via connections.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.

I don't believe you need to do steps 5-7. In fact, I think
these are filtering on the literal "[T1]".

Step 10 should set up all the filtering you need.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------



-----Original Message-----
COPIED FROM microsoft.publiv.sharepoint.windowsservices


John,

I like your suggestion, but I am obviously doing
something wrong. It says,
"There are no items to show in this view of the "test"
list.

Here is what I did.

1. Opened the Sharepoint site with FrontPage 2003
2. Created a Web Part page
3. Dragged the "test" list to the right column
4. Right click to open "List View Properties"
5. Clicked on Filter
6. Clicked on "Click here to add a new clause"
7. Entered Field Name "Last_Name"
Comparison "Contains"
Value "[T1]"
8. Dragged the "Form Web Part" to the left column
9. Right click on "Form Web Part" to open Web Part
Connections Wizard
10. Entered:
Provide Form Values To
Connect to a Web Part on this Page
Target Web Part "test" Target
Action "Get Sort/Filder
From"
Columns in Form Web Part "T1" Columns in
test "Last_Name"
Finished
11. Saved the page

What did I do wrong?


John


in message
Sorry I'm jumping in here late. I believe the steps
below will get you
what
you want using Connections from within FrontPage 2003...

Convert the view you want to be filtered into a Data
View Web Part using
FrontPage
Create a filter where your Field Name CONTAINS [Input
Parameter]

Insert a Form Web Part onto the page
Use Web Part connections to pass the Form value as a
parameter to the Data
View

Save the page.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties,
and confers no
rights.


.