FrontPage 2003 newbie needs database search form help

[Guest]

I'm using the Database Interface Wizard in Front Page 2003. I have no
trouble using the wizard to connect to a SQL Server database on a Windows
2003 server and create a results page and submission form. I have been unable
to wrap my head around how to set up a form for searching the database and
sending the search results to a Web page. Would some kind soul please help me
out?

 

[Kathleen Anderson [MVP - FrontPage]]

Use the Database Results Wizard. Create a new page, save it with a .asp
extension, and Insert | Database Results.

 

[Stefan B Rusynko]

Or see http://home.att.net/~codelibrary/FrontPage/buildquery.htm

--




| Use the Database Results Wizard. Create a new page, save it with a .asp
| extension, and Insert | Database Results.
|
| --
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
|
|
| | > I'm using the Database Interface Wizard in Front Page 2003. I have no
| > trouble using the wizard to connect to a SQL Server database on a Windows
| > 2003 server and create a results page and submission form. I have been
| > unable
| > to wrap my head around how to set up a form for searching the database and
| > sending the search results to a Web page. Would some kind soul please help
| > me
| > out?
| >
| >
|
|

 

[Guest]

Thank you very much.

Two more questions, if I may:

1. My Search form has a field for COUNTY. I'd like that to instead by a
drop-down box populated by choices from a table in my SQL Server database.
How do I do that?

2. The results of searches are displayed beneath the search form. How do I
separate the search form from the results it displays? In other words, I want
to make that single page two distinct pages.

Thanks again for the help. I'm a database guy, not a Web guy so this stuff
is really new to me.

Doug

 

[Kathleen Anderson [MVP - FrontPage]]

Inline (these solutions work with the DBRW and Access, not tested with SQL
Server).

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

 

[Guest]

Kathleen,

Thanks, again, for your help. Actually, I found the following on your Web
site for changing a text box to a drop-down list. It's much simpler than the
method in the MS KB article.
------

"How to change a text search box to a drop down?

If you go back to the Normal View of the Form, the following will change the
form field from a text box to a drop down and then you can look at the code
in HTML view and see the format:

Right click on the form field and select Form Field Properties.

Copy the field name, then cancel.

With the field still selected, use Insert | Form | Drop Down Menu to replace
the text field.

Then right-click and select Form Field Properties.

Paste the form field name into the name field and add your selections.

Courtesy of: Mark Rogers."

 

[Clark]

2. The results of searches are displayed beneath the search form. How do I
separate the search form from the results it displays? In other words, I want
to make that single page two distinct pages.

After you have generated the database results page with the search form on it,
go into html view and highlight the <form> and </form> tags and everything in
between, which contains the search code. Then do Ctrl-X to cut that code out of
the page onto the clipboard.

Save the page.

Then go the page where you want your search form (maybe you made a page with a
name like search.asp where you want your search form(s) to be), go to html view,
and paste the code for the form. Save the page, go to nomal view to see your
handiwork, and you are good to go.

Hint: before you go to the html view of the search.asp page to paste your code,
put a couple of spaces on that page exactly where you want your search form to
be and leave your cursor in that spot. Then go to html view. The cursor will
then be sitting right where you want to paste the code. After you have pasted
the code, save the page, go to normal view and there will be your search form
(at this point you probably want to delete the two spaces that you put in.

The nice thing about doing it this way is if you want to have several searches
on the same page. You can repeat the above process for other searches of
interest.