Help with searching a database with two drop down boxes

J

JackisBack

Hi all. I'm kind of a newb to frontpage and had a question about a
database I am working with. I am using Frontpage 2003 on a Windows
2003 server and all necessary extensions.

I have created a database and ASP pages that allow users to enter
educational links with other information so that others can access the
compile list. However, I am running into problems setting up the search
page.

The form that is filled out contains input for the name of the site, a
link, a description, checkboxes for grade level it applies to and also
the subject matter it pertains too.

For the grade level and subject, I used multiple check boxes so that
more then one choice could be picked if the user wanted multiple
entries.

I have created a search and results page but have been unsuccessful
getting the results to post. My search page has two drop-down menus
for subject and level. After choosing each, you Submit and I want it
to take you to the results screen where it will display just the links
that match the search request.

Again, I am kind of new to this but I am under the impression I will
need to insert a database results wizard on the results page and then
tie it to the submit button on the search page. Problem is I am not
sure how to code the button and setup the results wizard properly.

Am I on the right path?

In the database results wizard, do I need to set criteria to filter for
subject and level? Besides choosing the fields to publish is their
anything else special to do in the wizard?

As for the button, I am not sure really where to start. I know I have
to have it filter the database by the two drop-down fields, but not
sure how to code that.

Can anybody recommend a good site for coding asp in relation to what I
am trying to do.

Any insight and wisdom would be greatly appreciated.

Thanks in Advance.
 
S

Stefan B Rusynko

See http://support.microsoft.com/kb/235554 and the tips at http://spiderwebwoman.com/tutorials/doubledropdown.htm

--

_____________________________________________
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
_____________________________________________


|
| Hi all. I'm kind of a newb to frontpage and had a question about a
| database I am working with. I am using Frontpage 2003 on a Windows
| 2003 server and all necessary extensions.
|
| I have created a database and ASP pages that allow users to enter
| educational links with other information so that others can access the
| compile list. However, I am running into problems setting up the search
| page.
|
| The form that is filled out contains input for the name of the site, a
| link, a description, checkboxes for grade level it applies to and also
| the subject matter it pertains too.
|
| For the grade level and subject, I used multiple check boxes so that
| more then one choice could be picked if the user wanted multiple
| entries.
|
| I have created a search and results page but have been unsuccessful
| getting the results to post. My search page has two drop-down menus
| for subject and level. After choosing each, you Submit and I want it
| to take you to the results screen where it will display just the links
| that match the search request.
|
| Again, I am kind of new to this but I am under the impression I will
| need to insert a database results wizard on the results page and then
| tie it to the submit button on the search page. Problem is I am not
| sure how to code the button and setup the results wizard properly.
|
| Am I on the right path?
|
| In the database results wizard, do I need to set criteria to filter for
| subject and level? Besides choosing the fields to publish is their
| anything else special to do in the wizard?
|
| As for the button, I am not sure really where to start. I know I have
| to have it filter the database by the two drop-down fields, but not
| sure how to code that.
|
| Can anybody recommend a good site for coding asp in relation to what I
| am trying to do.
|
| Any insight and wisdom would be greatly appreciated.
|
| Thanks in Advance.
|
|
|
| --
| JackisBack
| ------------------------------------------------------------------------
| Posted via http://www.forum4designers.com
| ------------------------------------------------------------------------
| View this thread: http://www.forum4designers.com/message430206.html
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top