Stephen Green said:
Stephen Green said:
Kathleen Anderson said:
Stephen Green said:
Kathleen Anderson said:Stephen:
If I click on that link it will take me to my server, not yours
I would suggest creating a two cell table and put each DRW in its own cell.
To see how the first DRW is posting, in Normal View, right-click on the
form, select Form Properties, Send to other: Custom ISAPI, NSAPI, CGI, or
ASP Script. Click on Options and you should see the name of the results page
it is posting to. Follow the same procedure for the 2nd DRW and have it post
to the same page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Stephen Green said:
Stephen Green said:What an jerk I am! Here is the real link:
http://d758687.u36.infinology.net/drop_down_test_page_multiple.asp
The drop down on the left works (its the original); the one on the
right doesn't...
In fact, I did expand the table so the second drop down would be in
its own cell. And I checked to make sure the form was posting to the
right place - the same page.
Stephen
Kathleen Anderson said:Stephen:
If I click on that link it will take me to my server, not yours
I would suggest creating a two cell table and put each DRW in its
own cell. To see how the first DRW is posting, in Normal View,
right-click on the form, select Form Properties, Send to other:
Custom ISAPI, NSAPI, CGI, or ASP Script. Click on Options and you
should see the name of the results page it is posting to. Follow the
same procedure for the 2nd DRW and have it post to the same page as
the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Stephen Green said:
Kathleen Anderson said:What did you do with the Submit button from the second DRW? It seems that
the one you have is only taking it's order from the first one.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Stephen Green said:What an jerk I am! Here is the real link:
http://d758687.u36.infinology.net/drop_down_test_page_multiple.asp
The drop down on the left works (its the original); the one on the
right doesn't...
In fact, I did expand the table so the second drop down would be in
its own cell. And I checked to make sure the form was posting to the
right place - the same page.
Stephen
Kathleen Anderson said:Stephen:
If I click on that link it will take me to my server, not yours
I would suggest creating a two cell table and put each DRW in its
own cell. To see how the first DRW is posting, in Normal View,
right-click on the form, select Form Properties, Send to other:
Custom ISAPI, NSAPI, CGI, or ASP Script. Click on Options and you
should see the name of the results page it is posting to. Follow the
same procedure for the 2nd DRW and have it post to the same page as
the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
How do I do that? I tried creating a second drop-down at the top of
the page next to the first with different criteria, but it doesn't
seem to be linked properly to the query. Hitting Submit yields "No
records returned". See:
http://localhost/anmt/drop_down_test_page_multiple.asp.
Thanks again.
Stephen
message You can add a second DRW to the same page and have it post to the
same results page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Well, right after I hit Send, I fiddled a little more and now it
seems to work! I did change Equals to Contains. I don't know why
there is a blank space on the list, though...
Now that I have your attention, let me ask a question that I
posted a while ago but didn't get answered.
Is it possible to offer more that one drop-down to allow searching
by different criteria? Say by Zip Code or Age or...?
I tried creating the drop-down, but it wouldn't link properly to
the query.
Thanks so much.
Stephen
Kathleen!
You're right on the money. However, though I can get the sample
illustrated on the reference page to work, when I add the same
functionality to my existing page, it breaks.
The only difference I can see is that in my page the main query
is that my criterion reads [fieldname] Equals [fieldname]. If I
change the Equals to Contains, my query breaks.
Can you (anyone?) take a look at
http://d758687.u36.infinology.net/drop_down_test_page_all.asp to
see if you can spot the error?
I really appreciate it.
Stephen
message FP2000: How to Add an All Values Item to a Database Query
http://support.microsoft.com/default.aspx?scid=kb;en-us;q244968
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
When creating a drop down list for filtering a database query
(created with DRW) is there a way to add "All" to the list for
the option of NOT filtering the database?
for instance:
Criterion1
Criterion2
Criterion3
All
Thanks for your help.
Stephen
Stephen Green said:Kathleen!
I must be doing something wrong. The first drop-down and submit
button were created along withe the Database Results region below. I
can add more drop-downs using the DRW, but I don't get another submit
button. If I were to create a second DR region that would defeat the
purpose of having multiple selectors for the same region...
Thanks for tracking this.
Stephen
Kathleen Anderson said:What did you do with the Submit button from the second DRW? It seems
that the one you have is only taking it's order from the first one.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Stephen Green said:What an jerk I am! Here is the real link:
http://d758687.u36.infinology.net/drop_down_test_page_multiple.asp
The drop down on the left works (its the original); the one on the
right doesn't...
In fact, I did expand the table so the second drop down would be in
its own cell. And I checked to make sure the form was posting to
the right place - the same page.
Stephen
message Stephen:
If I click on that link it will take me to my server, not yours
I would suggest creating a two cell table and put each DRW in its
own cell. To see how the first DRW is posting, in Normal View,
right-click on the form, select Form Properties, Send to other:
Custom ISAPI, NSAPI, CGI, or ASP Script. Click on Options and you
should see the name of the results page it is posting to. Follow
the same procedure for the 2nd DRW and have it post to the same
page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
How do I do that? I tried creating a second drop-down at the top
of the page next to the first with different criteria, but it
doesn't seem to be linked properly to the query. Hitting Submit
yields "No records returned". See:
http://localhost/anmt/drop_down_test_page_multiple.asp.
Thanks again.
Stephen
message You can add a second DRW to the same page and have it post to the
same results page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Well, right after I hit Send, I fiddled a little more and now it
seems to work! I did change Equals to Contains. I don't know
why there is a blank space on the list, though...
Now that I have your attention, let me ask a question that I
posted a while ago but didn't get answered.
Is it possible to offer more that one drop-down to allow
searching by different criteria? Say by Zip Code or Age or...?
I tried creating the drop-down, but it wouldn't link properly to
the query.
Thanks so much.
Stephen
Kathleen!
You're right on the money. However, though I can get the
sample illustrated on the reference page to work, when I add
the same functionality to my existing page, it breaks.
The only difference I can see is that in my page the main query
is that my criterion reads [fieldname] Equals [fieldname]. If
I change the Equals to Contains, my query breaks.
Can you (anyone?) take a look at
http://d758687.u36.infinology.net/drop_down_test_page_all.asp
to see if you can spot the error?
I really appreciate it.
Stephen
in message FP2000: How to Add an All Values Item to a Database Query
http://support.microsoft.com/default.aspx?scid=kb;en-us;q244968
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
When creating a drop down list for filtering a database query
(created with DRW) is there a way to add "All" to the list
for the option of NOT filtering the database?
for instance:
Criterion1
Criterion2
Criterion3
All
Thanks for your help.
Stephen
Kathleen Anderson said:Ahhh ... I thought you wanted them to choose from one or the other. To
choose from both, you may want to try this:
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Stephen Green said:Kathleen!
I must be doing something wrong. The first drop-down and submit
button were created along withe the Database Results region below. I
can add more drop-downs using the DRW, but I don't get another submit
button. If I were to create a second DR region that would defeat the
purpose of having multiple selectors for the same region...
Thanks for tracking this.
Stephen
Kathleen Anderson said:What did you do with the Submit button from the second DRW? It seems
that the one you have is only taking it's order from the first one.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
What an jerk I am! Here is the real link:
http://d758687.u36.infinology.net/drop_down_test_page_multiple.asp
The drop down on the left works (its the original); the one on the
right doesn't...
In fact, I did expand the table so the second drop down would be in
its own cell. And I checked to make sure the form was posting to
the right place - the same page.
Stephen
message Stephen:
If I click on that link it will take me to my server, not yours
I would suggest creating a two cell table and put each DRW in its
own cell. To see how the first DRW is posting, in Normal View,
right-click on the form, select Form Properties, Send to other:
Custom ISAPI, NSAPI, CGI, or ASP Script. Click on Options and you
should see the name of the results page it is posting to. Follow
the same procedure for the 2nd DRW and have it post to the same
page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
How do I do that? I tried creating a second drop-down at the top
of the page next to the first with different criteria, but it
doesn't seem to be linked properly to the query. Hitting Submit
yields "No records returned". See:
http://localhost/anmt/drop_down_test_page_multiple.asp.
Thanks again.
Stephen
message You can add a second DRW to the same page and have it post to the
same results page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Well, right after I hit Send, I fiddled a little more and now it
seems to work! I did change Equals to Contains. I don't know
why there is a blank space on the list, though...
Now that I have your attention, let me ask a question that I
posted a while ago but didn't get answered.
Is it possible to offer more that one drop-down to allow
searching by different criteria? Say by Zip Code or Age or...?
I tried creating the drop-down, but it wouldn't link properly to
the query.
Thanks so much.
Stephen
Kathleen!
You're right on the money. However, though I can get the
sample illustrated on the reference page to work, when I add
the same functionality to my existing page, it breaks.
The only difference I can see is that in my page the main query
is that my criterion reads [fieldname] Equals [fieldname]. If
I change the Equals to Contains, my query breaks.
Can you (anyone?) take a look at
http://d758687.u36.infinology.net/drop_down_test_page_all.asp
to see if you can spot the error?
I really appreciate it.
Stephen
in message FP2000: How to Add an All Values Item to a Database Query
http://support.microsoft.com/default.aspx?scid=kb;en-us;q244968
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
When creating a drop down list for filtering a database query
(created with DRW) is there a way to add "All" to the list
for the option of NOT filtering the database?
for instance:
Criterion1
Criterion2
Criterion3
All
Thanks for your help.
Stephen
Stephen Green said:You were right the first time. What I would like to achieve is this.
Across the top of the page are several drop downs with appropriate
titles. The user chooses the most appropriate drop down for his
desired search result. The search result is displayed below.
Stephen
BTW, I do like the idea of the double dropdown...
Kathleen Anderson said:Ahhh ... I thought you wanted them to choose from one or the other.
To choose from both, you may want to try this:
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Stephen Green said:Kathleen!
I must be doing something wrong. The first drop-down and submit
button were created along withe the Database Results region below.
I can add more drop-downs using the DRW, but I don't get another
submit button. If I were to create a second DR region that would
defeat the purpose of having multiple selectors for the same
region...
Thanks for tracking this.
Stephen
message What did you do with the Submit button from the second DRW? It
seems that the one you have is only taking it's order from the
first one.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
What an jerk I am! Here is the real link:
http://d758687.u36.infinology.net/drop_down_test_page_multiple.asp
The drop down on the left works (its the original); the one on the
right doesn't...
In fact, I did expand the table so the second drop down would be
in its own cell. And I checked to make sure the form was posting
to the right place - the same page.
Stephen
message Stephen:
If I click on that link it will take me to my server, not yours
I would suggest creating a two cell table and put each DRW in its
own cell. To see how the first DRW is posting, in Normal View,
right-click on the form, select Form Properties, Send to other:
Custom ISAPI, NSAPI, CGI, or ASP Script. Click on Options and you
should see the name of the results page it is posting to. Follow
the same procedure for the 2nd DRW and have it post to the same
page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
How do I do that? I tried creating a second drop-down at the
top of the page next to the first with different criteria, but
it doesn't seem to be linked properly to the query. Hitting
Submit yields "No records returned". See:
http://localhost/anmt/drop_down_test_page_multiple.asp.
Thanks again.
Stephen
in message You can add a second DRW to the same page and have it post to
the same results page as the first.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Well, right after I hit Send, I fiddled a little more and now
it seems to work! I did change Equals to Contains. I don't
know why there is a blank space on the list, though...
Now that I have your attention, let me ask a question that I
posted a while ago but didn't get answered.
Is it possible to offer more that one drop-down to allow
searching by different criteria? Say by Zip Code or Age
or...?
I tried creating the drop-down, but it wouldn't link properly
to the query.
Thanks so much.
Stephen
Kathleen!
You're right on the money. However, though I can get the
sample illustrated on the reference page to work, when I add
the same functionality to my existing page, it breaks.
The only difference I can see is that in my page the main
query is that my criterion reads [fieldname] Equals
[fieldname]. If I change the Equals to Contains, my query
breaks.
Can you (anyone?) take a look at
http://d758687.u36.infinology.net/drop_down_test_page_all.asp
to see if you can spot the error?
I really appreciate it.
Stephen
"Kathleen Anderson [MVP - FP]" <[email protected]>
wrote in message
FP2000: How to Add an All Values Item to a Database Query
http://support.microsoft.com/default.aspx?scid=kb;en-us;q244968
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
When creating a drop down list for filtering a database
query (created with DRW) is there a way to add "All" to
the list for the option of NOT filtering the database?
for instance:
Criterion1
Criterion2
Criterion3
All
Thanks for your help.
Stephen