How to add an 'All Values' item in a filtered drop-down list query

[Kelly Ogreman]

I've been able to build a drop-down list that includes an 'All Values' item.
I've also been able to build a filtered database query using two drop-down
lists. But I don't know how to build a filtered list that includes an 'All
Values' item.

For instance the first drop-down has Accomodations, Attractions,
Restaurants. If Restaurants were chosen, then next drop-down only includes
Restaurant items like Fine Dining, Chinese, etc., not Hotel, which only
appears if Accomodations was chosen. But how do I include an 'All Values'
item in my drop-downs?

 

[Stefan B Rusynko]

Add an option using % as the value for All Values

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've been able to build a drop-down list that includes an 'All Values' item.
| I've also been able to build a filtered database query using two drop-down
| lists. But I don't know how to build a filtered list that includes an 'All
| Values' item.
|
| For instance the first drop-down has Accomodations, Attractions,
| Restaurants. If Restaurants were chosen, then next drop-down only includes
| Restaurant items like Fine Dining, Chinese, etc., not Hotel, which only
| appears if Accomodations was chosen. But how do I include an 'All Values'
| item in my drop-downs?

 

[Kelly Ogreman]

I tried that and it didn't work.
The first drop-down looks good, it has all the items and 'All Values'.
However if you choose 'All Values' the second drop down is blank. The second
(filtered) drop-down obviously doesn't know what to return when 'All Values'
is selected in the first drop-down. I also tried adding 'All Values' to the
second drop-down and it returns nothing.

 

[Kathleen Anderson [MVP - FrontPage]]

I think you can't do both. It might be possible to 'trap' the 'All Values"
selection and redirect them to another page with a different dropdown.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

I tried that and it didn't work.
The first drop-down looks good, it has all the items and 'All Values'.
However if you choose 'All Values' the second drop down is blank. The
second
(filtered) drop-down obviously doesn't know what to return when 'All
Values'
is selected in the first drop-down. I also tried adding 'All Values' to
the
second drop-down and it returns nothing.

Add an option using % as the value for All Values

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've been able to build a drop-down list that includes an 'All Values'
item.
| I've also been able to build a filtered database query using two
drop-down
| lists. But I don't know how to build a filtered list that includes an
'All
| Values' item.
|
| For instance the first drop-down has Accomodations, Attractions,
| Restaurants. If Restaurants were chosen, then next drop-down only
includes
| Restaurant items like Fine Dining, Chinese, etc., not Hotel, which only
| appears if Accomodations was chosen. But how do I include an 'All
Values'
| item in my drop-downs?

 

[Kelly Ogreman]

That's what I was starting to think. It's actually from Spider Web Woman that
I learned how to filter 2 drop-downs. So thank you twice.

I think you can't do both. It might be possible to 'trap' the 'All Values"
selection and redirect them to another page with a different dropdown.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

I tried that and it didn't work.
The first drop-down looks good, it has all the items and 'All Values'.
However if you choose 'All Values' the second drop down is blank. The
second
(filtered) drop-down obviously doesn't know what to return when 'All
Values'
is selected in the first drop-down. I also tried adding 'All Values' to
the
second drop-down and it returns nothing.

Add an option using % as the value for All Values

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've been able to build a drop-down list that includes an 'All Values'
item.
| I've also been able to build a filtered database query using two
drop-down
| lists. But I don't know how to build a filtered list that includes an
'All
| Values' item.
|
| For instance the first drop-down has Accomodations, Attractions,
| Restaurants. If Restaurants were chosen, then next drop-down only
includes
| Restaurant items like Fine Dining, Chinese, etc., not Hotel, which only
| appears if Accomodations was chosen. But how do I include an 'All
Values'
| item in my drop-downs?

 

[Stefan B Rusynko]

FYI
- Yes you can do both, but it means adding some server side scripting to pass variables
- the DBRW won't do it alone

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I think you can't do both. It might be possible to 'trap' the 'All Values"
| selection and redirect them to another page with a different dropdown.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| FrontPage Support: http://www.frontpagemvps.com/
|
|
|
|
| | >I tried that and it didn't work.
| > The first drop-down looks good, it has all the items and 'All Values'.
| > However if you choose 'All Values' the second drop down is blank. The
| > second
| > (filtered) drop-down obviously doesn't know what to return when 'All
| > Values'
| > is selected in the first drop-down. I also tried adding 'All Values' to
| > the
| > second drop-down and it returns nothing.
| >
| > "Stefan B Rusynko" wrote:
| >
| >> Add an option using % as the value for All Values
| >>
| >> --
| >>
| >> _____________________________________________
| >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> "Warning - Using the F1 Key will not break anything!" (-;
| >> To find the best Newsgroup for FrontPage support see:
| >> http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| >> _____________________________________________
| >>
| >>
| >> | >> | I've been able to build a drop-down list that includes an 'All Values'
| >> item.
| >> | I've also been able to build a filtered database query using two
| >> drop-down
| >> | lists. But I don't know how to build a filtered list that includes an
| >> 'All
| >> | Values' item.
| >> |
| >> | For instance the first drop-down has Accomodations, Attractions,
| >> | Restaurants. If Restaurants were chosen, then next drop-down only
| >> includes
| >> | Restaurant items like Fine Dining, Chinese, etc., not Hotel, which only
| >> | appears if Accomodations was chosen. But how do I include an 'All
| >> Values'
| >> | item in my drop-downs?
| >>
| >>
| >>
|
|