FrontPage 2003 / Access Database Search Question.

[Guest]

I want to search an access database field for one or more words and return
the records that have matches in that field. When I use the Database Results
Wizard it allows me to search the field for one word only. I would like to
modify the search box so that I can enter more than one word to search for.
At present if I enter more than one word it does not return any records. It
will find matches for one word only. Is there any way to enter more than one
word in a search box and search a field for matches and return the records?
Thanks for any replies.

 

[Guest]

With functionality like this, you end up having to custom build the search.
This is fairly easy in ASP, if you wish to go that route. It is not a built
in function of FrontPage database wizards, however.

If you want to build your own, you end up having to pull the form collection
yourself in an ASP page. You then have to split the string coming in. This
can be on spaces (quite common) or on a particular field type (comma, etc.),
although the latter forces the user to do things correctly.

You then have to custom build your SQL statement as there are many parts to
your where clause. After that, send to the database and get results.

We have MVPs who are better versed in the DRW and may know some easier
method. If so, it will be FP 2003 only, I would imagine.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************